Solved SUMIF not adding up correctly

July 5, 2017 at 13:59:25
Specs: Windows 7
My SUMIF is =SUMIF(B13,"New Form", B14:B17) and the total should be $13.00 but it says $7.00 which is the value in B14 so it is not adding the rest of the cells selected.

message edited by Nohemi


See More: SUMIF not adding up correctly

Reply ↓  Report •

#1
July 5, 2017 at 20:11:17
✔ Best Answer
Your SUMIF is working correctly as written.

As per the Office Support page for SUMIF:

The sum_range argument does not have to be the same size and shape as the range argument. The actual cells that are added are determined by using the upper leftmost cell in the sum_range argument as the beginning cell, and then including cells that correspond in size and shape to the range argument.

In your case, the upper leftmost cell in the sum_range argument is B14 and then the "cells that correspond in size and shape to the range argument" is still (and only) B14 since the range argument is a single cell: B13

Typically, the range argument is a range of cells, not a single cell. For example, based on the table below, this SUMIF will return 40 because there are 2 instances of John in the range argument B2:B5.

=SUMIF(B2:B5, "John", C2:C5)

          B         C
2       John        10
3       Bill        20
4       John        30
5       Sue         40


What exactly are you trying to SUM?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Reply ↓  Report •
Related Solutions


Ask Question