how do I calculate an input "c" to add certain cells?

G

Ginger

I am trying to develop a formula to calculate manpower.
I want to be able to add up all of the manpower that has an input of "C" in
another cell.
For Example
If Cell D8=C, then add to a final formula that cell E8=it's actual value...
does that make sense?
Thanks for any help.
 
K

Kevin M

Ginger, if i read that correctly..:

=IF(D8="c",SUM(E8,D8),"")

HTH,
Kevin M
MOS Excel Specialist
 
Top