Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing data by month
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing data by month
=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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing data by month
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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing data by month
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, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing data by month
Hi,
Here you can use pivot table. In layout of the pivot table, take date into row, and dollor into data then finish the pivot table after finishing the pivot, right click on the date in pivot table, click on Group and Show Details, click Group. In Grouping dialog box, select the option months and click on OK this will return the result you want Deepali Joshi "Valerie" wrote: 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, |
#6
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, |
Reply |
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 |