excel sum formula 1

[Bluejay07]

Hello,

I have a text column with a header. The values in the column will either be Y, N or blank. I am looking for a sum function that will count the total number of Y's in that column. I think I would need the sumif function, but I don't know the exact syxtax I would require.

Any help would be appreciated.
Thanks.

If at first you don't succeed, then sky diving wasn't meant for you!

 

[kjv1611]

COUNTIF

http://www.techonthenet.com/excel/formulas/

Other references

 

[SkipVought]

hi,

That would be the COUNTIF() function.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kjv1611]

Spent too much time formatting.

 

[Bluejay07]

Thank you both. Countif is the correct one I needed.

If at first you don't succeed, then sky diving wasn't meant for you!