Excel Countif formula for Excel 2003


Joined
Apr 26, 2009
Messages
2
Reaction score
0
I have Excel 2007 at home and have created a countif formula, but, at work we use excel 2003, so I need to convert these into a formula that 2003 will comprehend.

The formula is:
=COUNTIFS($A37:$II37,"<" & H42,$A37:$II37,">" & F42)
All being searched are numbers. In this case, I am trying to find the number of instances that fall between two set figures that appear in cells F42 (which is $105.00) and H42 (which is $129.00).

Suggestions?
 
Last edited:
Ad

Advertisements

Joined
Apr 27, 2009
Messages
6
Reaction score
0
Try this:

=COUNT(A3:A16)-COUNTIF(A3:A16,"<"&B3)-COUNTIF(A3:A16,">="&C3)

This counts the entire range, then removes the items outside your desired range.
 
Ad

Advertisements


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

Top