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

[popfan]

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.

[Richard Buttrey]

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

[popfan]

Thanks, looked all over for that answer