Hi,
I need to sumif the amount with the criteria of segment 'Cafe' and product
'mayo'.
I am using this function with the sheetname 'cafe S MTD07'. I should get a
return amount of 30 instead of 60.

SUMIF('cafe S MTD07'!A:A,B1,'cafe S MTD07'!C:C)

A B C
Segment Product Amount
1 Cafe Mayo 10
2 Cafe Mayo 20
3 Hotel Mayo 30
4 Cafe Pudding 30

Pls enlighten me...