function to count cells...

[malay_ko]

what function should i use to count cells not including empty cells
pls. see attachment

Attachment filename: quarter.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54035

 

[Andy B]

Hi

Try this:
=SUMPRODUCT((A3:A16<>"")*(B3:B16="1st quarter"))
=SUMPRODUCT((A3:A16<>"")*(B3:B16="2nd quarter"))
=SUMPRODUCT((A3:A16<>"")*(B3:B16="3rd quarter"))
=SUMPRODUCT((A3:A16<>"")*(B3:B16="4th quarter"))

 

[malay_ko]

thank you very much mr. andy