Countif but not quite

[Paul_tg]

Help,

I need a way to:

a) count the number of Sausage Sarnies with brown sauce
b) the total cost of the sausage sarnies with brown sauce.

A..............B....................C...................D
Sausage...White Bread.....Red Sauce.....2.50
Bacon.......Brown Bread...Red Sauce.....2.00
Bacon.......White.............Brown...........2.00
Bacon.......Brown............Brown...........2.00
Sausage...White..............Red...............2.50
Sausage...White..............Brown...........2.50


I thought I nearly had using Countif but couldn't figure out the sauce bit

Thanks for any help


Paul

[NBVC]

For multiple criteria, use Sumproduct()

e.g. =Sumproduct(--(A1:A10=X1),--(B1:B10=Y1)) to count

and =Sumproduct(--(A1:A10=X1),--(B1:B10=Y1),C1:C10) to sum

where A1:B10 contain lookup data separate columns... C1:C10 the summing data

X1, Y1, the criteria to look for.

[sweep]

Try these:

=SUMPRODUCT((A1:A6="Sausage")*(C1:C6="Brown Sauce"))
=SUMPRODUCT((A1:A6="Sausage")*(C1:C6="Brown Sauce")*(D1:D6))

[DonkeyOte]

Or if you're conducting multiple / similar calcs use a Pivot Table
(general intro. link in sig.)