SUMIFS Syntax

Using NUMBERS

Need to sum a column of numbers based on 2 conditions. One condition is that the range of cells is blank. What is the correct syntax?

iMac (M1, 2021)

Posted on Mar 11, 2024 7:14 AM

Similar questions

Issues with SUMIFS function Hey there, I'm working in a basic PoS spreadsheet for my business and I'm having problems when I tried to apply the same function but with different condition. In first picture the function works with the condition "Efectivo" but when change it to "Yape" (as you see in the second picture) the function give me a wrong result. The third picture shows the sum-values and test-values. I don't know why it can't work with the condition "Yape" if I typed it in the right way.
257 3
SUMIF formula not working in first row of Numbers table on iOS The SUMIF formula in first row of my table does not return a value. All other rows work correctly and return good values ? I’m a little unsure of formula structure or table setup. Thanks in advance…. [Edited by Moderator] Original Title: Numbers on iOS issue
377 2
Add cells if corresponding cell contains a value in Numbers I would like Numbers to scan a column, and if a cell in column A contains a number, it would sum the corresponding values in column B. For a simple example, in the pictured table, the values in B5, B7, and B10 would be excluded from the sum because the corresponding cells in column A do not contain numbers. When I try SUMIF(A3:A10,ISNUMBER(A3:A10),SUM(B3:B10)) I receive an error stating, "The range A3:A10 can't be used as a single value." I have tried playing around with the formula above, but I never seem to get the expected result.
364 3

2 replies

Badunit

Level 7

31,341 points

Mar 11, 2024 12:16 PM in response to Brenhamite

Use "" as the condition. This is a null string, two quotes with nothing in the middle.

Brenhamite Author

Level 1

4 points

Mar 15, 2024 9:52 AM in response to Badunit

Thank you.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

SUMIFS Syntax

Welcome to Apple Support Community

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

Learn more Sign up