how do I count cells containing only specific text?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that I would like to total the cells containing certain text
but not counting cells that contain other text.
 
Cells is an Excel term. Are you using Access here or Excel? If Excel, then
you should post in an Excel newsgroup.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Countif cell has diagonal border 6
Excel If a Cell Contains a Certain Text (From Another Table) 0
Excel Count Cells That Contain Text With "?" 0
Excel Excel Conditional Format 2
Excel Count If Formula Question 1
Excel Sum numbers in cells that also contain text 34
Excel VBA - counting cells by colors and names to it in two different rows. 0
Split column contents (de-concantenate) 7

Back
Top