Sumproduct Month VBA

Hi All,

I have range of data in SheetAI of attached file which contains Date (column B) and numbers (other columns). I am looking for a vba code to add numbers for each months in column AY. Exactly the same table in Sheet2 which I did with sumproduct but in VBA to display in table underneath VBA button. please see attache for more understanding. Any ideas how to get this?

Thanks.

Hello
With SUMPRODUCT in VBA, you have to use EVALUATE, for example to fill in your table for 2015 the following code should work:

Please Login or Register  to view this content.

DBY

Thank you so much that is exactly what I was looking for.

Originally Posted by DBY

Hello
With SUMPRODUCT in VBA, you have to use EVALUATE, for example to fill in your table for 2015 the following code should work:

Please Login or Register  to view this content.

DBY

Glad to have helped. Thank you for the Rep Mark.