VBA Sum Array Formulas

[annonymous33]

Hello Guy/Gals,

I hope we are all safe from Covid.


I lurk here a lot, but I am still trying to find my feet with VBA.


I am able to sum, but only with one (1) column of data. I want to move into array VBA. I've attached an example of array i want to put into VBA.

Using the index match match has proved to be somewhat troublesome and it would just be easier to use a sum array. Ive read loads of posts saying its not possible, but surely it is.

Thanks in advance for your help

Mark