Hi all,
I'm trying to sum specific columns of table based on the values of 2 other cells.
This is basically what I'm trying to accomplish:
IF($D$1="LOW"), =SUMIF(DATA[BR],L19,DATA[PRICELOW])
IF($D$1="MEDIUM"), =SUMIF(DATA[BR],L19,DATA[PRICEMED])
IF($D$1="HIGH"), =SUMIF(DATA[BR],L19,DATA[PRICEHIGH])
Is there a way to put this all into one formula?
Thanks!
Bookmarks