Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default sum daily production data to monthly

does anybody know how to summarize daily production data into monthly by
using functions?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 175
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting daily data into weekly, monthly and yearly data CEGavinMcGrath Excel Discussion (Misc queries) 4 April 3rd 23 06:54 PM
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET mike64149 Excel Discussion (Misc queries) 4 September 22nd 08 08:11 PM
Daily production worksheet for manufacturing gjsocha Excel Discussion (Misc queries) 0 April 24th 06 04:08 PM
Collecting weekly and monthly totals from daily data Kasper Excel Worksheet Functions 0 January 12th 06 09:02 PM
summing up daily data in a monthly compilation mark_vi_ Excel Worksheet Functions 2 June 22nd 05 01:07 AM


All times are GMT +1. The time now is 12:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"