Forum Discussion
Solved
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 fun...
=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
