| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum for date ranges
hi
culoumn a is date column b is numbers c1 cell is a report as at today input how do i write a formula to sum the contents of column B based on there date been in the last 7 days from report date |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum for date ranges
One way:
=SUMPRODUCT(--(A1:A10=C1-7),--(A1:A10<=C1),B1:B10) -- Biff Microsoft Excel MVP "Anthony" wrote in message ... hi culoumn a is date column b is numbers c1 cell is a report as at today input how do i write a formula to sum the contents of column B based on there date been in the last 7 days from report date |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a new calculated date from different date ranges? | Excel Worksheet Functions | |||
| If and Date Ranges | Excel Worksheet Functions | |||
| Using IF and date ranges | Excel Worksheet Functions | |||
| compare date to various date ranges and sum value | Excel Worksheet Functions | |||
| If then Date Ranges | Excel Worksheet Functions | |||
Hybrid Mode
