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

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 argumentis 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: B13Typically, 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

Ask Your Question

Weekly Poll

Do you agree with Google's decision to shut down Google+?

Discuss in The Lounge

Poll History