Hello,
This will likely be rudimentary to regular readers, but I'm stumped. Here's the situation:
An excel spreadsheet, the first column, say A1-A100, populated with about 13 different categories, say fruits.
The second - 20th columns, say B1-U100, populated with three different choices, say R, Y, or G, for each fruit.
I want to summarize the number of Rs, Ys, and Gs in a table, rows named for the fruits, columns with their respective headers.
Because of the complexity, a pivot table doesn't seem to be able to do the job. I've tried COUNTIF, but this wants to apply to the whole column, not break it down for each fruit.
Any suggestions?
Thanks for any and all help!
Rita
