Feb 08 2022 12:56 AM
Hi Excel Experts!
I’m trying to create a formula to sum referenced and filtered data base on an input year.
I have data being pulled from sheets based on different criteria and want to be able to QC against the sum of the values based on the year selected.
I’ve created a simplified version below:
B6 is a dropdown option to select years in B1:Q1
I want to be able to QC the number in L9 by looking up the input year in B6 and summing the data in the top table – i.e. in this case, from 2009 would be SUM(F2:N2)
I've tried a combination of IF and SUM and FILTER but need some expert advice! Thanks in advance
Feb 08 2022 01:26 AM - edited Feb 08 2022 01:33 AM
@pawswag What does "to QC a number" mean? And what's the logic for only summing 2009 through 2017?
Feb 08 2022 02:41 PM
Feb 08 2022 05:27 PM
Why from 2009 to 2017, not from 2009 to 2020 or 2015?
Feb 08 2022 05:31 PM
Feb 08 2022 09:35 PM
Solution@pawswag Still don't understand what "quality checking a number" means, but perhaps the attached file contains the type of solution you are asking for.
Feb 08 2022 09:35 PM
Solution@pawswag Still don't understand what "quality checking a number" means, but perhaps the attached file contains the type of solution you are asking for.