Trying to use a SUMIF for a YTD

[Excelhelppleasethank]

Hello All,

I am attempting to do a Sum IF that spans across multiple months, however I am not sure if the function is capable of doing so. Please refer to the attached file to see the problem I have run into. I have seen a combination of Offset, and Index Match used to solve a different issue. I was wondering is Sumif possible to use in this scenario, if not what is the easiest remedy that require the least amount of monthly maintenance. Thanks for your help in advanced!

[popipipo]

Try this index match formula

Please Login or Register  to view this content.

[angelos1111]

i dont want with pivot. I tried with vlookup but brings me the same name. Any idea what can i do?

[FlameRetired]

@ angelos1111

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread