I have the following table:
The following formula returns 13 as I expect it to.![]()
Person Food Units Olof Ice Cream 11 Olof Chili 2 Jocke Frysmat 8 Jocke Pizza 2 Alex Lasange 7 Andrea Kvarg 13
The following formula returns 0 when I expect it to return 11. Why doesn't it return 11?![]()
=SUM(IF(A2:A7="Olof";C2:C7;0))
![]()
=SUM(IF(AND(A2:A7="Olof";B2:B7="Ice Cream");C2:C7;0))
Bookmarks