ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need to find out how many are in a column (https://www.excelbanter.com/excel-discussion-misc-queries/128924-need-find-out-how-many-column.html)

smolz

Need to find out how many are in a column
 
I have spreadsheet that has a column that tracks a ticket priority
(1-Critical, 2-high...) I want to at the bottom of the sheet track how many
there are of each type, ie:

25 1-critical
50 2-high

Alan

Need to find out how many are in a column
 
With the list in column A, in B1 and B2 or wherever
=COUNTIF(A1:A100,1)
=COUNTIF(A1:A100,2)
Regards,
Alan.

"smolz" wrote in message
...
I have spreadsheet that has a column that tracks a ticket priority
(1-Critical, 2-high...) I want to at the bottom of the sheet track how
many
there are of each type, ie:

25 1-critical
50 2-high





All times are GMT +1. The time now is 08:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com