Counting the occurrence of "Y" & "N" in Excel 2007
I'm just now trying to learn the COUNTIF function but obviously am having a
problem...
If the cell range is (A5:A370) and I need to count the "Y" 's and the "N"
's with the answer resulting in the following format: YYYY/NNNN what would
I use?
Any help apreciated!
--
~Christi
|