Can I make an "IF" or "COUNT" statement that says:
I B2 0, but C2 and D2 and E2 and F2 = 0

Also, the raw data has some blanks, N?A, ? in the fields. Will this have to
be cleaned up first? I noticed on a "=SUM" it was not a problem.

I've tried pivot tables, but can't get mutually exclusive fields.
Thanks again.

"DTTODGG" wrote:

Hello - I need help fast.
I have a large spreadsheet that looks like this:
A2 = Customers
B2 = Oranges
C2 = Apples
D2 = Grapes
E2 = Bananas
F2 = Kiwi

I need a report that shows:
How many have Oranges only?
How many have Apples only?
How many have Grapes only?
etc.

I also need a report that ranks the customer by the most number of Kiwi's,
while still showing the count of the other fruits.

Please help!