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.

SUMIF

Is it possible for the condition of a SUMIF to refer to another table on the same sheet? It doesn't seem to work!


I have a table with 80 or so rows of numerical data. When I write a few rows on the same table using SUMIF to total up amounts in a column that meet certain criteria in another column then it works fine. However, when I write the same formula in another table referring to my data table, it doesn't seem to work. Not a syntax error but just seems to ignore the 'condition' part of the statement.


Any ideas would be much appreciated, thank you.

Mac mini (M1, 2020)

Posted on Apr 28, 2023 4:24 AM

Reply
Question marked as Top-ranking reply

Posted on Apr 28, 2023 8:40 PM

Hi Pete,


Glad to help. Yes, you can specify a range. I was making use of Numbers' ability to refer to all the body rows of a table. It ignores Header Rows (Row 1 in my example) and Footer Rows (not present in my example). Take a look in Template Chooser to see excellent examples of the Numbers approach (several small tables, each with a purpose).


Regards,

Ian.

4 replies
Question marked as Top-ranking reply

Apr 28, 2023 8:40 PM in response to buro46_Pete

Hi Pete,


Glad to help. Yes, you can specify a range. I was making use of Numbers' ability to refer to all the body rows of a table. It ignores Header Rows (Row 1 in my example) and Footer Rows (not present in my example). Take a look in Template Chooser to see excellent examples of the Numbers approach (several small tables, each with a purpose).


Regards,

Ian.

Apr 28, 2023 6:10 AM in response to Yellowbox

Many thanks Ian, you have saved the day! I was just going to send you a copy of the formula that I used, which is similar to the one you suggested, only I had specified a precise range.


When I copied and pasted I realised I had my columns the wrong way round, ie instead of SUMIF(test-values, condition, sum-values) I effectively had SUMIF(sum-values, condition, test-values) so no wonder it didn't work!


Anyway, many thanks again for your time.

SUMIF

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