COUNTIF with several criteria

Hi there,

I have a spreadsheet where I would like to add a summary pane.

One of the summaries should count rows meeting multiple criteria being values in several separate columns. I thought I would be able to use:

=COUNTIF($I$35:$I$1000,"G1")+ COUNTIF($I$35:$I$1000,"R")+ COUNTIF($I$35:$I$1000,"N")

However, it doesn't work. I have searched the net and tried a load of alternative methods but I just cannot get it to work.

Can you HELP???

Thanks

Thanks very very much for the speedy reply!

My mistake. The values to "R" and "N" are in column S. So how do I specify two ranges? Your suggestion returns 0.

Thanks

Your ROCK! It works a treat.

Thank you so much!