Hi All,

I have an excel document with 2 sheets.

The first sheet (Called "Data") is a huge amount of "Raw Data" relating to clients, providers etc...

The second sheet is used to pull relevant info from the "Data Sheet"

Column I on the data sheet has a list of providers.

A7 has a certain relevant provider i have specified to gather information on

"Data" Column "O" has a list of monetary values e.g 7.14

What i need is the calculation to return the following:

If the text in Column I on the data sheet matches the text column A7 on "Sheet2" and the value of column "O" on the data sheet is between 0 and 100 (lets say thats a $ amount) i need the calculation to return the number of times there is a value between 0 and 100.

Current formula:

=SUMPRODUCT(--(Data!I:I=A7),--(Data!O:O<=100),Data!O:O)

If what i am asking is not clear at all let me know

Help much appreciated

thanks