On Tuesday, December 17, 2013 6:59:11 PM UTC+5:30, Claus Busch wrote:
Hi San,



Am Tue, 17 Dec 2013 05:23:32 -0800 (PST) schrieb San:



But if I use a cell reference for a date, like, Countifs(A2:A200,"=A2", B2:B200.....) where cell A2 contains 01/04/2013, the formula is not working.



with cell reference you have to write "="&A2. For your example try:

=COUNTIFS(A1:A200,"="&A2,B1:B200,"=505",C1:C200, "=87")





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Thanks Claus. Will try it out.

San