• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

sumifs with variable sum range possible?

V

Vilene

New Member
Hello,

I'm stucking a bit with following problem (or maybe using the wrong approach for my problem ...).

I need the sum of actual month (in this case February) for the conditions given in column A and B - so per "CC" (as column A) and "Part" (as column B). But it should be automated this way, that I don't need to adjust formula in March again, but Excel jumps by giving the value of the reporting month to the correct column to summarize.
So far I worked with sumifs, what is quite okay if you have a stable sum range, but not, if you need changing ranges.

I'm open for any other formula too, as long as I do not need to adjust it all the time.

Thanks in advance!
Vilene
 

Attachments

Hi,

Welcome to the board!!!!

I am little confused about your query but you would use indirect/named range/offset for dynamic range.
 
Hello Vilene, and welcome to the forum. :)

Take a look at the attached, where I setup a SUMIFS formula which has the sum range change based on which month you want to look at. I wasn't sure from your example how to know which month is the "Actual month", so I just went with a dropdown in the example, but we can change this if needed.
 

Attachments

Hello and thank you for the warm welcome :-)

@Luke - yes perfectly that's what I was looking for even with a confusion question from my side ...

Thanks very much!!!!
 
You must log in or register to reply here.
Back
Top