Sumif with selecting cells to the left of the active cell

[mike_vr]

Hi all,

Been stuck on this for a while. I am trying to insert a Sumif formula in a cell that references a static row and condition (in this case row 5 and a condition in row 4), but am having trouble defining a dynamic range for the selection of the cells to the left of the active cell, as the columns will increase each month.

This is what I've got from researching the internet and a lot of trial and error, but I always get a user defined error message whenever I run it?

Please Login or Register  to view this content.

Any help would be immense!

Thanks,

Mike

[mike_vr]

OK after much head scratching and trial and error I came up with a solution/work around.

Please feel free to have a look and run of the attached code, best I could do with my limited abilities but works quite nicely for my needs.

Any hints/improvements please feel free to let me know

Cheers,

Mike