Hi,

Am Fri, 22 Mar 2013 15:32:56 -0700 (PDT) schrieb Please work this
time...:

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")

please look into help for this function:
"Importantly each additional range must the same number of rows and
columns as the argument criteria range1"
So you have to split AP8:AR107 to three columns:
=COUNTIFS(Sheet3!C8:C107,"*",Sheet3!AH8:AH107,"*", Sheet3!AO8:AO107,"*",Sheet3!AP8:AP107,"<=500",Shee t3!AQ8:AQ107,"<=500",Sheet3!AR8:AR107,"<=500")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2