I have the following sheet:

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.

1 Answer

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)

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy