Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a list of revenue broken down by transaction for the past four years.
I want to see the total amount of revenue generated during the month of December 2006 v. December 2008. Right now, my dates on the spreadsheet are in the form 12/31/2006. What type of formula should I use to do this? I have tried this but it is coming up with nothing and I can see that there were sales during the month of December 2006. =SUMIFS(M:M,I:I,"<=(12/31/2006)",I:I,"=(12/01/2006)") Thank you for all of your help offered. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIF? week, month & year-to-date totals | Excel Worksheet Functions | |||
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
trying to get day/month/year froamt while user enters year only | New Users to Excel | |||
How to use month() and day() without considering year()? | Excel Worksheet Functions |