Excel counting columns

Question

I want something very similar to the above. Consider input like

GL15
GL15
GL15
GL16
GL17
GL17
GL17

The above column is just one of the columns in a sheet. I want the output to be

GL15 3
GL16 1
GL17 3

I was hoping Pivot Table would solve this. So I added the column as a "Row Label" but I cannot get the count to work.

Please can someone provide some instructions?

Using `COUNTIF` wouldn't work there? – JMax May 12 '12 at 21:22 — JMax, May 12 '12 at 21:22

chris neilsen · Accepted Answer · 2012-05-12T23:40:19.987

4

Here how to setup the Pivot Table:

enter image description here

Procedure:

Select data
Insert Pivot Table
Drag Item from Choose Fields list into Row Labels
Drag Item from Choose Fields list into Values (defaults to Count)

edited May 12 '12 at 23:40

answered May 12 '12 at 23:14

chris neilsen

52,446
10
84
123

Seems like just what the doctor ordered, but what steps did you do to get there? – Rob I May 12 '12 at 23:24
Exactly what I wanted !! The trick is to drag the "Item" column into the "Values". – Kannan Ekanath May 13 '12 at 19:59

score 0 · Answer 2 · answered May 12 '12 at 21:22

I think this will help ..

Salesperson Invoice
Buchanan    15,000
Buchanan    9,000
Suyama      8,000
Suyama      20,000
Buchanan    5,000
Dodsworth   22,500

Formula Description (Result)

=COUNTIF(A2:A7,"Buchanan")  Number of entries for Buchanan (result = 3)
=COUNTIF(A2:A7,A4)  Number of entries for Suyama (result = 2)
=COUNTIF(B2:B7,"< 20000")   Number of invoice values less than 20,000 (result = 4)
=COUNTIF(B2:B7,">="&B5) Number of invoice values greater than or equal to 20,000 (result = 2)

try like this,. if you want some help tell . I think this will help ..

Thank you... Sampath Sri Anuradha Web Designer and Developer

Excel counting columns

2 Answers2