Counting cells

[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

[Bob Phillips]

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)


"David494" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> David494
> ------------------------------------------------------------------------
> David494's Profile:
http://www.excelforum.com/member.php...o&userid=24482
> View this thread: http://www.excelforum.com/showthread...hreadid=390875
>