sum daily production data to monthly
 

does anybody know how to summarize daily production data into monthly by
using 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?

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?

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?

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?