Hello

i have a slight issue with trying to summarise of raft of rowed data as enclosed
I need to summarise by month where currently the database is by week - I have been trying to use Sum Product but this doesn't work - issue is it not only needs to summarise by month across thecolumns but also by factory by row
could anyone please help with this ?

thank you

peterSumProductProblem.xls