Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting cells
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 |
#2
|
|||
|
|||
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
Counting unique text/number cells from a range | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
complex fomula: counting cells that are blank | Excel Worksheet Functions | |||
Counting blank cells in Pivot Table | Excel Worksheet Functions |