sumproduct or countif

[mamig]

I want to look at a column for a specific entry. Then looking in another column count how many times there is a corresponding entry in a specific range. Example: in column B look for the entry R1. Then look in column C for an entry from 18 to 25 that corresponds to R1 and give a count of the entries. I have been looking at sumproduct and countif and can't figure a way to enter the range criteria. A sample spreadsheet is attached.

[DonkeyOte]

No attachment but in general:

=SUMPRODUCT(($B$1:$B$100="R1")*($C$1:$C$100>=18)*($C$1:$C$100<=25))
(keep ranges as lean as possible)

In XL2007 and beyond use COUNTIFS in preference to the above.

[mamig]

Thank you. That solved it.