how do I count cells containing only specific text?

A

accountant

I have a table that I would like to total the cells containing certain text
but not counting cells that contain other text.
 
R

Rick B

Cells is an Excel term. Are you using Access here or Excel? If Excel, then
you should post in an Excel newsgroup.
 
S

Steve Schapel

Accountant,

I am assuming you mean count the records rather than a sum of values?
Make a query based on your table, and add the field in question to the
query design grid. In the criteria, put the equivalnt of...
Like "*your text*"
Make it a Totals Query (select Totals from the View menu), and put Count
in the Totals row of the grid.
 
Top