COUntif AND...

S

Shane Devenshire

Hi,

If you are using 2007 you can write

=COUNTIFS(A2:A100,">="&B1,A2:A100,"<="&C1,B2:B100,D1)
 

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

possible countif formula? 3
Countif gone wrong 2
COUNTIF with 2 columns 2
COUNTIF AND COUNTIF 3
Formula Count dates multiple criteria 3
IF(AND)Etc..... 3
countif using other cell values for 'range' and 'criteria' 4
Countif function 3

Top