Sum column but include only cells that have matching criteria in multiple columns in same row

Question

I have an Excel spreadsheet with four columns, call them A, B, C, and Value. What I want to do is sum the Value column but only include those cells that have a certain criteria matching in columns A, B and C.

An example, in English: SUM the values in the Value column that have a value of 6 in column A, a value of 10 in column B and a value less than 15 in column C.

Thanks

Answer 1

Make a table like the attached image in excel.

In B10 put:

=SUMIF(A2:A8,B14,B2:B8)

In the B14 put the criteria.