| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF by Week.
How can I sum a range of cells, identifing them by week.
For example, I have column B with dates, and colum C has different numbers. I want to use a SUMIF function on A1 that automatically adds different cells from column C which are included in this week. Something like this, =SUMIF(B1:B100,TODAY(),C1:C100) but instead of TODAY(), I want to use this week. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
| SUMIF? week, month & year-to-date totals | Excel Worksheet Functions | |||
| Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
| How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Threaded Mode
