kltinaheart
New Member
- Joined
- Apr 20, 2018
- Messages
- 14
Hey all!
so ive been at this for 4 hours -.-
If I have lets say a
Column A for item type - Gloves, masks, shoes
Column B for Size - Sma, Med, Lar
Column C for prices - 5.00, 10.00, 15.00
I want a formula to look at the variable in Column A (this I can manually type in the formula, lets say gloves)
So IF Gloves, and IF Column B says "Med", then give me the Highest price for all Medium gloves.
So far I tried (=MAX(IF(D2:D17="Gloves",O2:O18))) which is supposed to work fine, but doesn't on my excel
(=SUMPRODUCT(MAX((D2:D17="Gloves")*O2:O18))) Which is supposed to work fine but doesn't.
Then finally...
=MAX(INDEX((Table1[Item Type]="Gloves")*Table1[Price per Unit],0)) Which works Great, but I only have 1 criteria (whether or not it says Gloves)
Can I add some kind of Gloves AND Med, give me max price?
thank you!!
tina
so ive been at this for 4 hours -.-
If I have lets say a
Column A for item type - Gloves, masks, shoes
Column B for Size - Sma, Med, Lar
Column C for prices - 5.00, 10.00, 15.00
I want a formula to look at the variable in Column A (this I can manually type in the formula, lets say gloves)
So IF Gloves, and IF Column B says "Med", then give me the Highest price for all Medium gloves.
So far I tried (=MAX(IF(D2:D17="Gloves",O2:O18))) which is supposed to work fine, but doesn't on my excel
(=SUMPRODUCT(MAX((D2:D17="Gloves")*O2:O18))) Which is supposed to work fine but doesn't.
Then finally...
=MAX(INDEX((Table1[Item Type]="Gloves")*Table1[Price per Unit],0)) Which works Great, but I only have 1 criteria (whether or not it says Gloves)
Can I add some kind of Gloves AND Med, give me max price?
thank you!!
tina