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