help with sumif to calculate column

[rvnwdr]

Good morning,

I was wondering if someone can help me with a sumif formula. I have a
column where either P, I, or NT in entered. I would like to add up
each of the P's, I's and NT's.
ex: cell I38 would calculate all P entries in column X
cell I40 would calculate all I entries in column X
cell I42 would calculate all NT entries in columnX

Thanks for your help

 

[greg7468]

Hi,
if you just want to count the occurrences of P, I and NT use

=COUNTIF(X:X,"P")

HTH.

 

[rvnwdr]

Because not all fields are entered I am getting a #value.

Am I missing something?

 

[Dave Peterson]

What formula did you use?

What's in those ranges when the fields are missing?