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.
= +
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.