I’m able to use SUMIF to return sum of all cells that fit one criteria:
=SUMIF(DATA!$U$3:$3, “Previous Age”,DATA!$U9:9)
However, I’d like to add another criteria: to match $F$2 with 1st criteria’s OFFSET (,,1).
=SUMIF(DATA!$U$4:$4, DATA!$U$3:$3&OFFSET(DATA!$U$3:$3,,1),”Previous Age”&$F$2)
=SUMIF(DATA!$U$4:$4, (DATA!$U$3:$3=”Previous Age”)*(OFFSET(DATA!$U$3:$3)=$F$2))
The above two formulas do not work, but hoping it still conveys what I’m trying to do.
the cells in question are highlighted in teal.
attached is the file
New contributor
Chulho Chang is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.