Excel Countif formula for Excel 2003

[vaggy2009]

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?

 

[tsshaw78]

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.

 

[vaggy2009]

Thanks.


That works