COUNT IF COLUMN X="" COUNT COLUMN Y?

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

Guest

Hi

really simple one.

I need a formula that will count if coumn B is greater than 0, when column A
= a certain field of text.

Thanks for your help
 
=SUMPRODUCT(--(B1:B1000>0),--(A1:A1000="text"))

SP cannot work on a whole column so you have to nominate the range.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

counting blank cells within two columns 2
Help with IF - THEN 5
Sumproduct question 4
Count with multiple column criteria 2
Formula Help 2
move sum to different columns 2
Conditional Formatting - Reference to multiple column 3
compare 2 columns and select the lowest 2

Back
Top