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?
SUMIFS(C12:C26,E12:E27,FALSE,F12:F26,F26)
I double- and triple-checked before posting, and yet it was my error that caused this (one of the arguments was not the same size E12:E27) . My apologies, thanks.
How are you expressing the three arguments used in the formula?
IOW: Please show us the formula.
Regards,
Barry
Hi capn,
Apologies not necessary. Good to see that another look solved the issue.
Regards,
Barry
Range can't be used as single value error for SUMIFS in numbers
