Dynamic range sumifs

Hi, I am looking to sum a running current month to date total. So end of February it will show total Jan to Feb and end of March will show Jan to March. I've tried a few variations of sumifs & index match but haven't been able to figure it out. Sheet(target est) Col A1 is a join then c-n are Jan- dec data. Sheet (BvA)has the same join info in Col a and a reference date in e5. I need to match the joint Col b/t the 2 sheets then match the date in sheet 2 and total all the data on sheet 2 up to that date. Thanks

Please post a small sample file (not image) showing expected results.

Originally Posted by JohnTopley

Please post a small sample file (not image) showing expected results.

Sorry tried that the first time and it didn't let me...it may be because it logged me out

Try

=SUMPRODUCT(('Target Est'!$C$4:$N$8)*('Target Est'!$C$2:$N$2<=BvA!$E$2)*('Target Est'!$A$4:$A$8=BvA!$A4))

Copy down

Originally Posted by JohnTopley

Try

=SUMPRODUCT(('Target Est'!$C$4:$N$8)*('Target Est'!$C$2:$N$2<=BvA!$E$2)*('Target Est'!$A$4:$A$8=BvA!$A4))

Copy down

Awesome man worked perfect...thank you for helping me add sum product to my tool belt

You're welcome.

Can you mark thread as solved: "Thread Tools" at top of first post.