Entering multiple ranges in a countif formula

  • Thread starter Thread starter Christine Ilott
  • Start date Start date
C

Christine Ilott

Anyone know how to enter multiple ranges in a countfi formula?

The ranges are B3:B77 and N3:N50, the value is in M59 and the result is to
be displayed in N59
 
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

Cell reference in formula string displays abbreviated value 2
Excel Need Countifs Formula Help 0
COUNTIF on result of formula 4
COUNTIF Cells in Range? 4
Sorting and COUNTIF 6
Vlookup will not retrun value 2
Excel Dragging countif formula with changing criteria 3
COUNTIF, Sorting, on Two Sheets 1

Back
Top