Forum Discussion
Multiple conditions
I wanted to create a cell that can fetch the data needed with multiple conditions regarding my table below.
e.g. I want to sum up the price of all category CAT1 of unit U1
im not sure what function to use. i tried using IF, SUMIF and Vlookup but it seems i needed another function.
=SUMIFS(Price,Category,Category_value,Unit,Unit_value)Or a pivot table.
Category and unit into rows area.
Price into values area.
=SUMIFS(Price,Category,Category_value,Unit,Unit_value)Or a pivot table.
Category and unit into rows area.
Price into values area.
- Thanks! I've been putting so much function into one cell without luck, now with this I can just use a single function. On pivot tables, it still confuses me. I'll be using sumifs in the mean time
