HI-
The below SumProduct formula references a specific Month. How can I amend for below 2 scenarios:
1) A specific date. Example. 2/21/14, 2/20/14, etc
2) 1 one week time frame. Example 2/10/14 to 2/14/14, etc.
Please Login or Register to view this content.
For the first one, just drop the MONTH. For the other, use two comparisons, >=, and <=.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Can you take a look at my spreadsheet. I created a quick example. For some reason it is not working when I do equals the date. The numbers aren't returning what I expect. test.xlsx
Because Z column is look like date, but not dates.
Try to use column B instead (if possible), if not, in next column of Z, try:
AA2=DATE(RIGHT(Z2,4),LEFT(Z2,2),MID(Z2,4,2))
Drag down
Copy and Past Special / Value back to Z column.
Quang PT
That didn't work for me either. Maybe I need to switch my fomula to a sumif? If so, how would that look?
Couple of problems. The dates aren't dates, they're text that look a bit like date.
And the formula should be:
Formula:
Please Login or Register to view this content.
That works for Asia in cell A7.
Note that you need commas to separate the elements or use * to multiply the elements together.
Regards, TMS
Thank you. One more question. Would below work for a 1 week time frame if dates are correct in b1, and b2?
Please Login or Register to view this content.
nevermind I figure it out. THanks guys
You're welcome. Thanks for the rep.
I suspect you worked out that you'd need to split the two date comparisons.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks