Back again with the countif.

I am using the following now, but i realised an error in my logic.
What needs to happen is that if the first 3 conditions are correct then I need to return the count of of all the columns AP8:AP107,AQ8:AQ107 & AR8:AR107 that
have a value <=500.

=COUNTIFS(Sheet3!C8:C107,"*",Sheet3!AH8:AH107,"*", Sheet3!AO8:AO107,"*",Sheet3!AP8:AP107,"<=500",Shee t3!AQ8:AQ107,"<=500",Sheet3!AR8:AR107,"<=500")

thanks again



On Saturday, March 23, 2013 4:20:12 PM UTC-5, Please work this time... wrote:
On Friday, March 22, 2013 5:32:56 PM UTC-5, Please work this time... wrote:

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







On Friday, March 22, 2013 5:32:56 PM UTC-5, Please work this time... wrote:

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. I will try the SUMPRODUCT also,







So any help is accepted.







thanks a lot



Thank you guys , I really appreciate the help I will post back if I have a issue with the guidance you guys provided.