3

I have the following sheet:

enter image description here

I want a sum of individual spending by Frank, John and Nancy in the yellow cells. Each person's spending is denoted by an x. I tried the SUMIF formula, but I don't know how to denote criteria to be the existence of a value in the cell.

Or perhaps I am simply using the wrong formula for this type of task.

AngryHacker
  • 19,327

1 Answers1

6

The Syntax for SUMIF, according to the relevant microsoft support article:

SUMIF(range, criteria, [sum_range])

For example, the formula =SUMIF(B2:B5, "John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal "John."

In your case that would be

=SUMIF(G2:G15, "x", D2:D15)
mashuptwice
  • 3,395