Hi.
I have a pivot table with 17,000 rows and 6 columns. The data is just a
count of what is in the columns.
Example: of fruit eaten during a day
apple oranges bananas total
bob 1 1 0 2
jane 1 0 1 2
fred 0 0 1 1
sue 0 0 0 0

How would I count up all the times that only a banana was eaten during a
day? Use an array or Formula? Not sure how I would do this with a pivot
table.

Thanks,
Chris