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)

"steph44haf" wrote:

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.