Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try
=SUMPRODUCT(--(LEFT(nd!$B1:$B10000,2)="BD"),--(nd!$EC1:$EC10000=DATE(2009,10,1)),--(nd!$EC1:$EC10000<DATE(2009,10,31))) I assume you are using 2007 since you are using B:B but I would refrain from using that for 2 reasons, your workbook will become very slow and if you ever save this in 97-2003 format the formula will return a NUM error when someone with <=2003 opens it -- Regards, Peo Sjoblom "Tom" wrote in message ... Hello, I have some data that I need to count based on two criteria. The tab name for the data is "nd". The first two characters of column B shows the market ID. I then need it to go to column EC and count what dates are in october, november, december and 2010 and beyond. This is the formula I've been using, but I can't get the date format correct: =SUMPRODUCT(-(LEFT(nd!$B:$B,2)="BD"),-(nd!$EC:$EC=10/1/2009<10/31/2009)) Can someone tell me how I should be entering in the date? Thanks, Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT and dates | Excel Discussion (Misc queries) | |||
sumproduct with dates | New Users to Excel | |||
SUMPRODUCT - DIFFERENT DATES | Excel Worksheet Functions | |||
Sumproduct and dates | New Users to Excel | |||
SUMPRODUCT and Dates | Excel Worksheet Functions |