Jan 19 2022 08:41 AM
So I am trying to use the VLOOKUP or XLOOKUP function to find corresponding values in my data.
Say I have some financials listed quarterly:
2015
Q1 - $2000
Q2 - $3000
Q3 - $4000
Q4 - $1000
2016
Q1 - $4000
Q2 - $500
Q3 - $1000
Q4 - $5000
and so on.
Is there a way I can find the sum of the values for all of one specific quarter?
All I seem to know is -
XLOOKUP(Q3,A2:A50,B2:B50) but this would just return one value rather than summing all the Q3 results.
If that makes sense.
Thanks.
Jan 19 2022 08:52 AM
Jan 19 2022 09:18 AM
Jan 19 2022 09:50 AM
Did you enter e.g. "Q1" and "2000" in seperate cells? It doesn't work if "Q1 - 2000" is in one cell as shown in the attached file. Maybe you want to attach an example copy of your file with dummy data.
Jan 19 2022 11:18 AM