Adding Columns in Excel

DNA · May 10, 2005

I have a row that has only Y's or N's. I want to total in two other
difference cells the number of Y's and the number of N's in that row.

Any ideas?

Nick Hodge · May 10, 2005

DNA

Use a COUNTIF function for each like that below

=COUNTIF(A1:G1,"Y")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]