countif formula

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

Guest

hello,
i want make COUNTIF formula with two Colums detail is as under.

1- ex: =COUNTIF( A1:A10=CAR & B1:B10>=50)
2- ex: =COUNTIF(A1:A10 >=10 & A1:A10 <=100)

Please help me.
Thanks/Tufail
 
=SUMPRODUCT(--A1:A10="CAR"),--(B1:B10>=10))

The second can be done with two COUNTIFs as it tests the same range

=COUNTIF(A1:A10,">=10")-COUNTIF(A1:A10,">100")

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)
 

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
VBA Countif across sheets? 5
Excel Copy COUNTIF while retaining reference 7
Sum / countif data range 2
unique records in specified range 5
Help with VBA............Again. 7
range names 4
How to do this with macro? 2

Back
Top