I have 2 columns. 1 column with items and 1 with the number 1 as a count.
The items may have several of the same item. I would like to be able to count the total of items.
Example
Col1 Col2
Blue Glass 1
Blue Glass 1
Red Glass 1
Green Glass 1
Red Glass 1
Blue Glass 1
Black Glass 1
I would like to have a count that says:
Blue Glass 3
Red Glass 2
Green Glass 1
Black Glass 1
Any help would be appreciated
Thank you in advance
Assuming column-A holds the item:
=COUNTIF($A$1:$A$100,"Red Glass")
Adjust the formula for each "glass".
However, A pivot table work well for this.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Thank you very much for your assistance.
problem Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks