Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countifs Function not giving desired result with date criteria
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countifs Function not giving desired result with date criteria
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countifs Function not giving desired result with date criteria
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIFS with a date for criteria... | Excel Worksheet Functions | |||
countifs criteria includes date range | Excel Worksheet Functions | |||
which function can get the desired result? | Excel Worksheet Functions | |||
Function giving a result for number within a range | Excel Worksheet Functions | |||
giving points by a result (function) | Excel Worksheet Functions |