COUNTIF & AND Functions

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

Guest

I'm trying to do a COUNTIF formula using two conditions.

=COUNTIF(AND(R2:R900="AG",AM2:AM900<0))

but the above formula doesn't work.

Any help would be apprecaited

Thanks
 
=COUNTIF(AND(R2:R900="AG",AM2:AM900<"0"))

For reasons known only to Bill Gates COUNTIF requires that number values be
enclosed in double quotes.

Dave
 
Couldn't get the COUNTIF statement below to work but the SUMPRODUCT formula
works GREAT!

Thanks!
 
Dave F said:
=COUNTIF(AND(R2:R900="AG",AM2:AM900<"0"))

For reasons known only to Bill Gates COUNTIF requires that number values be
enclosed in double quotes.
Click to expand...
....

And for reasons known only to you, you didn't test this ti find out
that it can't even be entered as-is in any version of Excel. It's a
great big syntax error.
 
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

Excel Need Countifs Formula Help 0
Finding the weighted average of text that have been given values 1
countifs Function not giving desired result with date criteria 2
using CountIF function or Array? 3
CountIf previous cell formula 0
Countif gone wrong 2
Countifs function equivalent for Excel 2002 (XP) 1
countif 3

Back
Top