Counting with multiple conditions

R

Rohan

Hi!

I want to count rows in a worksheet for which column 1 has value =
"some string" and column 2 has value > "some number".

I am trying to get this info using COUNTIF function. But looks like
this function has space for only one crieteria.

Is there any way to have this in a excel farmula?

Thanks,
Rohan
 
P

papou

Hello Rohan
Try: =SUMPRODUCT((A1:A10="YourString")*(B1:B10>YourNumber))

Please note Sumproduct function does not accept entire colum adresses

HTH
Cordially
Pascal
 

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

Dynamic hyperlinks not working 4
Excel How to count from a column if specific condition in another column is true 3
how to convert COUNTIF() into VBA macro 0
Counting multiple memberships 1
Conditional Formatting with VBA 4
Excel Concatenate with line breaks but ignore blank cells 3
Counting Duplicates on two sheets 2
Excel VBA 1

Top