countifs Function not giving desired result with date criteria

S

San

Hi,

I have a table where the Column A has dates in sequential format, Column B contains the Average temperature values as on respective dates, Column C contains Average Pressure values as on respective dates.

When I am using Countifs(A2:A200,">=01/04/2013",B2:B200,">=505",C2:C200,">=87"), I am getting the correct count

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.

How can I use the Countifs function correctly with a "between dates criteria",where the dates are referenced from cells

Thanks

San
 
C

Claus Busch

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.
 
S

San

Hi San,



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






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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top