Summing a range of cells based on criteria in another range


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.
 
Ad

Advertisements

P

Pete_UK

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
 
Ad

Advertisements

J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top