Multiple conditions

[Jootin]

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.

[#2 · Accepted solution]

@Jootin 

=SUMIFS(Price,Category,Category_value,Unit,Unit_value)

Or a pivot table.

Category and unit into rows area.

Price into values area.

[#3]

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