Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumIf by Date?
Is there an easy way to sumif row entries based on dates, without having to
create an additional column for an additional formula? (i.e. month()) In other words... I have several large ongoing database, and would like to sum sales figures by month. The information I want to use as a criteria is the Close Date, which is dd/mm/yy. I would normally insert an additional column adjacent to the Close Date column, do a month(), then sumif by month # in this new colomn. Is there an easier way to do this? I really don't want to have to include an additional column, and for some reason, I'm not 100% on the accuracy of this method. Am open to guidance by Those Who Know on this forum! Muito thanks, JM_Brazil -- I have chosen not to write anything in this space. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif date is greater than or equal chosen date | Excel Discussion (Misc queries) | |||
Sumif....date in table is greater than compared to date | Excel Discussion (Misc queries) | |||
sumif < date | Excel Worksheet Functions | |||
SUMIF for date | Excel Discussion (Misc queries) | |||
SUMIF within date range as a function of today()'s date | Excel Worksheet Functions |