Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum based on date from a cell
Ok maybe I can explain this better than my previous attempt... I am trying
to stream line my work flow so I have created a "Monthly Results" sheet that has a single field D4 where the user will input the first day of the month ex. "03/01/2007". I have below D4 a cell that should return the sum of the "hours on" (column B) for the month represented by the single date entry found in D4. How can I set my criteria to ref the single date in D4 but look for the entire month? thanks - will |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum based on date from a cell
One way
=SUMPRODUCT(--(YEAR(A2:A50)=YEAR(D4)),--(MONTH(A2:A50)=MONTH(D4)),B2:B50) Where A2:A50 holds the dates and B2:B50 what you want to sum -- Regards, Peo Sjoblom "Will" wrote in message ... Ok maybe I can explain this better than my previous attempt... I am trying to stream line my work flow so I have created a "Monthly Results" sheet that has a single field D4 where the user will input the first day of the month ex. "03/01/2007". I have below D4 a cell that should return the sum of the "hours on" (column B) for the month represented by the single date entry found in D4. How can I set my criteria to ref the single date in D4 but look for the entire month? thanks - will |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selection based on a date in a cell | Excel Discussion (Misc queries) | |||
Change cell in formula based on date | Excel Discussion (Misc queries) | |||
Autofill date based on date in another cell | Excel Worksheet Functions | |||
How do I change content of a cell based on date | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |