sumifs & index & match

[BeckyLH88]

Hello everyone,

I've been staring at this for a long while now. I have been using this formula:

=SUMIFS(INDEX(Budget!$E$4:$P$41,0,MATCH($B$4,Budget!$E$1:$P$1,0)),Budget!$B$4:$B$41,$C7)

Where B4 = the date.

E4 to P41 = the data range to sum
E1 to P1 = dates by end of month date
B4 to B41 = account code

This formula is fine, if I am just looking at the current month; but I cannot work out in this formula how I can include prior months to give me a YTD total, for example July & August. At the moment this formula just gives me August.

I appreciate any help please :D

Many thanks!

 

[Fluff]

As this is now a different question, it needs a new thread. Thanks

 

[BeckyLH88]

Thank you, I've cracked it. Thank you so much for your help. I'd have been staring at it for a few weeks!

 

[Fluff]

Glad to help & thanks for the feedback.