Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Problem
Hello All,
I was wondering if you could help me, I am using the following formula in Excel 2003. =SUMPRODUCT(--(E3:E129<=(NOW()))) This is basically telling me any values that are before the current date (i.e Expired training). The formula works OK but is counting blank cells (Not everyone has done the training!!). Can anyone let me know how to amend this formula to exclude blank cells. Many Thanks Mark |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Problem
=SUMPRODUCT(--(E3:E129<=NOW()),--(E3:E129<""))
"Mark Hanson" wrote: Hello All, I was wondering if you could help me, I am using the following formula in Excel 2003. =SUMPRODUCT(--(E3:E129<=(NOW()))) This is basically telling me any values that are before the current date (i.e Expired training). The formula works OK but is counting blank cells (Not everyone has done the training!!). Can anyone let me know how to amend this formula to exclude blank cells. Many Thanks Mark |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Problem
=SUMPRODUCT((E3:E129<=NOW())*(E3:E129<""))
Note that if you are looking at just date, rather than time, you may want to change NOW() to TODAY(), and you may want < rather than <= if you are looking at dates before today. -- David Biddulph "Mark Hanson" wrote in message ... Hello All, I was wondering if you could help me, I am using the following formula in Excel 2003. =SUMPRODUCT(--(E3:E129<=(NOW()))) This is basically telling me any values that are before the current date (i.e Expired training). The formula works OK but is counting blank cells (Not everyone has done the training!!). Can anyone let me know how to amend this formula to exclude blank cells. Many Thanks Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another formula problem | Excel Discussion (Misc queries) | |||
Formula problem | Excel Discussion (Misc queries) | |||
formula problem | New Users to Excel | |||
Problem with Formula | Excel Worksheet Functions | |||
Formula problem | Excel Worksheet Functions |