does anybody know how to summarize daily production data into monthly by using functions?
O olga Mar 9, 2009 #1 does anybody know how to summarize daily production data into monthly by using functions?
M Mike H Mar 9, 2009 #2 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
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
F francis Mar 9, 2009 #3 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
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
A Ashish Mathur Mar 9, 2009 #5 Hi, You can use pivot tables and group dates by months -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com
Hi, You can use pivot tables and group dates by months -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com
