Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum daily production data to monthly
does anybody know how to summarize daily production data into monthly by
using functions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum daily production data to monthly
Hi,
it would be a lot easier to help had you provided your data layout. this sums column B if the date in a1 is february =SUMPRODUCT((MONTH(A1:A20)=2)*(B1:B20)) Mike "olga" wrote: does anybody know how to summarize daily production data into monthly by using functions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum daily production data to monthly
Its is not clear as to what you want.
would you post a sample of what you have and your expected result -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "olga" wrote: does anybody know how to summarize daily production data into monthly by using functions? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum daily production data to monthly
I did of course mean if the Month on Column A is february
"Mike H" wrote: Hi, it would be a lot easier to help had you provided your data layout. this sums column B if the date in a1 is february =SUMPRODUCT((MONTH(A1:A20)=2)*(B1:B20)) Mike "olga" wrote: does anybody know how to summarize daily production data into monthly by using functions? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum daily production data to monthly
Hi,
You can use pivot tables and group dates by months -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "olga" wrote in message ... does anybody know how to summarize daily production data into monthly by using functions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting daily data into weekly, monthly and yearly data | Excel Discussion (Misc queries) | |||
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET | Excel Discussion (Misc queries) | |||
Daily production worksheet for manufacturing | Excel Discussion (Misc queries) | |||
Collecting weekly and monthly totals from daily data | Excel Worksheet Functions | |||
summing up daily data in a monthly compilation | Excel Worksheet Functions |