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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I calculate an input "c" to add certain cells? (https://www.excelbanter.com/excel-worksheet-functions/31052-how-do-i-calculate-input-%22c%22-add-certain-cells.html)

Ginger

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

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)

"Ginger" wrote in message
...
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.

Kevin M

Ginger, if i read that correctly..:

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

HTH,
Kevin M
MOS Excel Specialist

"Ginger" wrote:

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.

All times are GMT +1. The time now is 10:48 PM.