F FT OFFICE Mar 24, 2004 #1 Can anyone tell me why this won't work? =COUNTIF(AND(COLLECT!A2:A501="GL",COLLECT!J2:J501="APP"),B1)
H Harald Staff Mar 24, 2004 #2 Sure. Countif and Sumif can only evaluate one range. HTH. Best wishes Harald
F Frank Kabel Mar 24, 2004 #3 Hi try the following instead =SUMPRODUCT((COLLECT!A2:A501="GL")*(COLLECT!J2:J501="APP")) not sure what you're trying to achieve with the 'B1' part in your original formula
Hi try the following instead =SUMPRODUCT((COLLECT!A2:A501="GL")*(COLLECT!J2:J501="APP")) not sure what you're trying to achieve with the 'B1' part in your original formula
D Don Guillett Mar 24, 2004 #4 try sumproduct((COLLECT!A2:A501="GL")*(COLLECT!J2:J501="APP")*(dontunderstandthe rest,B1))
