=SUMPRODUCT((B2:B200="Apples")*(C2:E200))

--
__________________________________
HTH

Bob

"Will" wrote in message
...
Dear All,

Kindly assist me with a table that i needed to count a sum with citeria

example:

John's: Day1 Day2 Total
Apples 50 100 150
Oranges 80 150 230
Papaya 100 50 150

Mark's
Oranges 150 50 200
Apples 100 50 150
Papaya 80 80 160

So on.........................

total Apples: 300
total Oranges: 430
total Papaya: 310

As there are hundreds of Names, i wonder whether there are a functions
that
that "apples" as ref and count the total sum of it.