Summing a range of cells based on criteria in another range

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

A8 = 300 B8 = 600 C8 = sum of B8-A8 or 300 D8 = 100% E8
= +
A9 = 200 B9 = 150 C9 = sum of B9-A9 or = -50 D9 = -25.0% E8
= -
A10 = 100 B10 = 100 C10 = sum of B10-A810 or = 0 D9 = 0.0% E8 = 0

The formula I need will scan the E column for all cells that contain a "+",
then add those cells in the C column that correspond, delivering one total.
Same for the "-" and the "0" in E column.

Appreciate any help.
 
Try these:

=SUMIF(E:E,"+",C:C)

for the + sign, and:

=SUMIF(E:E,"-",C:C)

for the negatives, and:

=SUMIF(E:E,0,C:C)

for the zero values.

Hope this helps.

Pete
 
Try
=SUMIF(E:E,"+",C:C)
=SUMIF(E:E,"-",C:C)

You can do that without using colE as
=SUMIF(C:C,">0")
=SUMIF(C:C,"<0")


If this post helps click Yes
 
Back
Top