Lookup / find value formulae

Gaurav Chauhan · 04/21/22

Hi there, need help with the formulae.

Sheet 1 is where the data is input and will look like that

Sheet 2 is my summary for calculation and formuale to populate graphs

the third table is how the $ value would get populated for building graph. Can you please confirm the formulae

Paul Newcome · 04/21/22

Try...

=SUMIFS({Value Column}, {Type Column}, @cell = Type@row, {Year To Buy Column}, @cell = 2022)

Answers