Excel Function asmallsnowball2007-07-08 21:35:10

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

回复：It will not work.

回复：Excel Function

=COUNTIF(B2:B30, "Apple")