COUNTIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the formula (syntax) for counting multiple ranges? I have looked,
and suprisingly not found anything on it.

I am trying to find the number of occurences of a number >1 in ranges A1:c10
and G50:X60.

Thanks for any help
 
How about just adding two =countif()'s?

=countif(a1:c10,">"&1) + countif(g50:x60,">"&1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Creating a count when the information from two cells is true. 2
Counting cells in a selectable date range 0
place array at calculated position 2
Countif formula perhaps 7
How do I use countif like sumif ie (range,criteria,count_range) 1
Limit Scrollarea 11
CF Warning Formula 1

Back
Top