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

[Guest]

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.

 

[N Harkawat]

Try

=sumif(D1:d100,"C",E1:100)

 

[Guest]

Ginger, if i read that correctly..:

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

HTH,
Kevin M
MOS Excel Specialist