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?