Thread: Sum of a column based of 2 critiera and summing a different column

I am trying to get column 4 to sum up based on a value in column 1 and based a value in Column 3. I have a index - match formula there right now, but it does sum all items that match the required critiera.

Hi,

An INDEX() function can only return one value. You should be using SUMIFS()
i.e.
=SUMIFS(D:D,A:A,"Cold East",C:C,"Regular")

Note that you could also filter the data for Cold East and Regular and use =SUBTOTAL(9,D2:D28)

Regards