How can I subtotal my weekly totals by months?

S

steph44haf

I have a plot of 5 item types going down the left side and then the values
plotted to the right with the corresponding week dates above each. I want to
take that data and subtotal by months or put it into Access to subtotal by
month.
 
D

duane

here is an example

SUMPRODUCT((MONTH(B4:D4)=6)*(B5:D5))

where the dates are in B4:D4, and the data to be subtotalled in B5:D5

the above sums for the month of June ( month 6)
 
Top