Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create a formula in Excel that will countif or sumif bef.
How do I create a formula in Excel that will countif or sum if before or
after a specific date? Whenever I put the actual date in the formula it works, but when I reference to the cell the date is in it returns 0. |
#2
|
|||
|
|||
If the cell contains a date, it will contain some number like 37756 or
something. If your formula with hand written date is =SUMIF(G3:G5,""&"10/1/2002",H3:H5) try putting 10/1/2002 (ensure Excel knows it's a date. you can format it as a number to be sure) in H1, then you can use =SUMIF(G3:G5,""&H1,H3:H5) "bkclark" wrote in message ... How do I create a formula in Excel that will countif or sum if before or after a specific date? Whenever I put the actual date in the formula it works, but when I reference to the cell the date is in it returns 0. |
#3
|
|||
|
|||
Try this:
=COUNTIF(A1:A20,""&C1) With the date in C1. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "bkclark" wrote in message ... How do I create a formula in Excel that will countif or sum if before or after a specific date? Whenever I put the actual date in the formula it works, but when I reference to the cell the date is in it returns 0. |
#4
|
|||
|
|||
I use the following and get the correct result
=COUNTIF(B4:B7,""&B10) where B10 holds the date "bkclark" wrote in message ... How do I create a formula in Excel that will countif or sum if before or after a specific date? Whenever I put the actual date in the formula it works, but when I reference to the cell the date is in it returns 0. |
#5
|
|||
|
|||
Hi Dave
just as a note: This won't work in some/most European countries. If you want a hardcoded string better to use the ISO date format: =SUMIF(G3:G5,""&"2002-10-1",H3:H5) -- Regards Frank Kabel Frankfurt, Germany "Dave R." schrieb im Newsbeitrag ... If the cell contains a date, it will contain some number like 37756 or something. If your formula with hand written date is =SUMIF(G3:G5,""&"10/1/2002",H3:H5) try putting 10/1/2002 (ensure Excel knows it's a date. you can format it as a number to be sure) in H1, then you can use =SUMIF(G3:G5,""&H1,H3:H5) "bkclark" wrote in message ... How do I create a formula in Excel that will countif or sum if before or after a specific date? Whenever I put the actual date in the formula it works, but when I reference to the cell the date is in it returns 0. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Creating an EXCEL COUNTIF formula for a range of values | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
How do I create a multi formula IF function in Excel? | Excel Worksheet Functions | |||
how do i create a blank cell in excel using a formula | Excel Worksheet Functions |