EXCEL FORMULA

[SC03OTT]

hey

i have had a bit of a memory blank moment. i have a column in excel with either 'Y' or 'N' in each cell. whats the formula I need to add up all the 'Y's, giving me a total?

cheers

 

[Galzzly]

=COUNTIF(A1:A30,"=Y")

Where A1:A30 is the column containing the Y's and N's

 

[Andy.]

Count If
^^ edit: too late, what he said

 

[MarkCup]

As above...

 

[SC03OTT]

cheers folks!