You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Range can't be used as single value error for SUMIFS in numbers

I am not new to Apple, Numbers or spreadsheets. I'm getting a "range can't be used as single value" error in numbers for the following: SUMIFS(sum-values,test-values,condition) where sum-values is supposed to be a range. The odd thing is that the test-values range is ok. Any help on this?

Posted on Nov 13, 2021 1:47 PM

Reply
3 replies

Range can't be used as single value error for SUMIFS in numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.