SUMIF formula?

Question

Level 2

380 points

SUMIF formula?

hi all

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

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

Answer 1

SGIII

Level 8

37,532 points

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

You can do this:

=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

Answer 2

Barry

Level 9

60,023 points

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

Hi ric,

Syntax error in your formula.

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