Excel Function

Is there a function / way I can use to return the numbers of Total Apples, Oranges, Mellons, for each person in 30 days?

name Day1 Day2 Day3 Day30 AppleTotal OrangeTotal MellonT.
Kelly Apple Apple Apple Orange
Kelly Orange Orange
Dave Orange Orange Orange Orange
Charlie Apple Mellon Mellon Mellon
Truck Mellon
Kidd Apple Orange Orange Orange
Ron Apple Orange Orange Orange
......


Thanks,

所有跟帖： 

• Data--> subtotals -不提也罢- ♂ (0 bytes) () 07/08/2007 postreply 14:40:44

• 回复：It will not work. -asmallsnowball- ♀ (226 bytes) () 07/08/2007 postreply 15:04:25

• 回复：Excel Function -伍小笔- ♂ (3 bytes) () 07/09/2007 postreply 08:17:00

• =COUNTIF(B2:B30, "Apple") -Westmont- ♂ (90 bytes) () 07/09/2007 postreply 19:05:00