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?