Quote:
Originally Posted by daveshookme
No there really is no need for it. One of the joys in this project is it's just a learning thing for me, overcomplicating things just to learn new functions, logic my way through new problems/find alternative or easier ways to solve something, etc.
I was learning how to dynamically name ranges using the offset function. It's not a huge deal, I figured it that part out. It just wasn't working with the sum. No big deal.
|
I mostly use dynamic ranges when using pivot tables. They're really great if you have no empty columns across the top row and at least one row with no gaps in data. Otherwise, at least in my experience, they begin to get very tricky to create. By utilizing the SUMIFS function, you can produce the same result and save yourself the time of creating a bunch of named ranges.