Counting cells

  • Thread starter Thread starter David494
  • Start date Start date
D

David494

Hey

I have a spreadsheet, which is connected to a SQL Server database. The
spreadsheet searches by date and then gets all the info between the two
dates and displays it on the worksheet.

I then sort all of the columns accending, but sorted by column 1. The
idea is to count the number of cells where for example "column 1 =
General Enquiry". To do this I scroll down, find all the General
Enquiry entries, select them all and then paste them into a new
worksheet, which gives the number of entries for that category type.

Is there a way to do this through perhaps using a button/interface?

Thanks everyone

Dave
 
You can do it with a formula

=COUNTIF(A:A,"General Enquiry")

or drop the data into a pivot table

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top