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

SUMIF formula?

hi all


this should be obvious to me by now, but it's not, maybe it's a Friday afternoon thing....!!



User uploaded file



am i right in using the SUMIF formula here? i'm simply wanting to add up the sums, but only those where the preceding column indicates "yes"...??


thanks, ric

macOS Mojave (10.14)

Posted on Oct 12, 2018 7:43 AM

Reply
Question marked as Top-ranking reply

Posted on Oct 12, 2018 8:41 AM

You can do this:


User uploaded file




=SUMIF(A,"yes",B)


It's not clear from your screenshot which columns you are working with, so I've assumed the numbers you want to sum are in column B and that the yes/no column is column A. You would replace the A and B to fit your setup.


Note that in my example Row 11 is defined as a Footer Row (choose 'Convert to Footer Row' from the dropdown that appears beside the row number at the left) so you can put a formula in that row that refers to the same column. In Numbers it's often more convenient to refer to the entire column rather than a range of rows with a column as is common in Excel. But you can, of course, use a range of cells as you have in your example.


Replace the , in the formula with ; if your region uses , as a decimal separator.


SG

4 replies
Sort By: 
Question marked as Top-ranking reply

Oct 12, 2018 8:41 AM in response to ric frankland

You can do this:


User uploaded file




=SUMIF(A,"yes",B)


It's not clear from your screenshot which columns you are working with, so I've assumed the numbers you want to sum are in column B and that the yes/no column is column A. You would replace the A and B to fit your setup.


Note that in my example Row 11 is defined as a Footer Row (choose 'Convert to Footer Row' from the dropdown that appears beside the row number at the left) so you can put a formula in that row that refers to the same column. In Numbers it's often more convenient to refer to the entire column rather than a range of rows with a column as is common in Excel. But you can, of course, use a range of cells as you have in your example.


Replace the , in the formula with ; if your region uses , as a decimal separator.


SG

Reply

Oct 13, 2018 1:33 AM in response to ric frankland

Hi ric,


Syntax error in your formula.

User uploaded file

SUMIF(test-values, condition, sum-values)


SUMIF(C350:C358,"=yes",E350:E358)

OR

SUMIF(C350:C358,"yes",E350:E358)


Will work.

COUNTIF (and the rest of the …IF functions) require the comparison operator, where included, to be presented as text, as in the first example. But if the comparison is 'equal to', the operator may be omitted, as in the second example.


Regards,

Barry

Reply

SUMIF formula?

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