Formula that specifies value of filters

[Steele3252]

Hi,

This may seem like one of the easier questions asked here, but I've spent all day trying and haven't found a way.

If you look at L25 for example, there is a formula for that specific cell. This formula updates itself whenever I change any of the 3 filters in rows 7, 8 and 9.

I want a formula where I specify the 3 filters and get the value of L25.

For example, if Quarter = 2, Distribution = Career, Product Design = Grand Total, the formula would give 0, as that is what the L25 formula yields when those filters are set.

Intuitively this seems like it should require a super easy formula, so if anyone could help find it I would be extremely grateful since I've spent a really long time on it.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Formula that specifies value of filters
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.