Summing a range of cells based on criteria in another range
 

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.

Summing a range of cells based on criteria in another range
 

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

On Nov 4, 11:52*pm, Jack wrote:
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.

Summing a range of cells based on criteria in another range
 

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
---------------
Jacob Skaria


"Jack" wrote:


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.