Hi,

I have a spreadsheet with 4 different criteria and all of them have to be true in order for me to get the count I desire. In the formula below the first 3 critera evaluate fine but then the formula does not evulate the last criteria. Here is the formula:

I want to get a count if all the criteria are correct ie if there is something in Sheet3!C8:C107 & Sheet3!AH8:AH107 & Sheet3!AO8:AO107 & Sheet3!AP8:AR107 values are less than or equal to $500.00.



=COUNTIFS(Sheet3!C8:C107,"=?",Sheet3!AH8:AH107,"=? ",Sheet3!AO8:AO107,"=?",Sheet3!AP8:AR107,"<=50 0")

The formula evulates correctly untill it hits Sheet3!AP8:AR107 values are less than or equal to $500.00. then I get an error.

So any help is accepted.

thanks a lot