Google-sheets – Help using 2 parameters to output a specific category

formulasgoogle sheetsgoogle-sheets-arrayformulagoogle-sheets-queryvlookup

I'm looking to be able to enter an "AGE" and a "V02" in a formula that tells me what "category" the person would be in ie; good, excellent, etc.

=ARRAYFORMULA(HLOOKUP(I2, {VLOOKUP(I1, A2:G, {2,3,4,5,6,7}, 1); B1:G1}, 2, 1))

You can use the =SUMIF as MaryC says, or the =FILTER function that I usually prefer:

  =SUM(FILTER(F2:F, B2:B = "/Online Computers"))

The =FILTER function filters your data so that only rows matching B2:B = "/Online Computers" are included.

I would recommend a pivot table but you might use something like:

=SUMIF(C:C,J2,D:D)

copied down, where J2 is the first entry in the table driving the drop-downs.