| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing data by month
Oops, good spot!
-- __________________________________ HTH Bob "Valerie" wrote in message ... Bob - I got it! Needed a parenthesis just before the word month. thank you "Valerie" wrote: I have tried this for "April" and "January" however it keeps bringing back 0. Can you recheck? Parenthesis ? Thanks "Bob Phillips" wrote: =SUMPRODUCT(--MONTH(A2:A200)=4),B2:B200) should do it for April -- __________________________________ HTH Bob "Valerie" wrote in message ... I have random dates in one column (formatted as: April 13, 2009) and dollar values in the column next to the dates. How can I sum, for example, all April dollars or all June dollars? I have another tab that is summarizing the data by month. So, the data is summarized in this tab with each month alpha listed ("April", or "June"). Can I sum all "April" data that is formatted as mm/dd/yyyy? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing values in a column if the date in another is of a certain month | New Users to Excel | |||
| Summing values in a column if the date in another is of a certain month | Excel Worksheet Functions | |||
| summing daily data by month | Excel Worksheet Functions | |||
| Summing up of data for this month | Excel Discussion (Misc queries) | |||
| Summing Values In Current Month Only | Excel Worksheet Functions | |||
![Bob Phillips[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
