O
olga
does anybody know how to summarize daily production data into monthly by
using functions?
using functions?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
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
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
F
francis
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
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
M
Mike H
I did of course mean if the Month on Column A is february
A
Ashish Mathur
Hi,
You can use pivot tables and group dates by months
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
You can use pivot tables and group dates by months
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com