I'm attempting to sum numbers based on the values in my first two columns. For instance, if column A=East and Column B=Hats, add the values in column C, in this case 100.
East Hats 100
West Shoes 20
North Hats 30
South Shoes 40
East Shoes 50
I thought I could use an array formula with an If and an AND in it.
This is the formula I attempted, which didn't work.
SUM(IF(AND($A$4:$A$8="East",$B$4:$B$8="Hats"),$C$4:$C$8))
Any suggestions?
East Hats 100
West Shoes 20
North Hats 30
South Shoes 40
East Shoes 50
I thought I could use an array formula with an If and an AND in it.
This is the formula I attempted, which didn't work.
SUM(IF(AND($A$4:$A$8="East",$B$4:$B$8="Hats"),$C$4:$C$8))
Any suggestions?