Dcount with Text

C

ChuckN

I would like to use the something like the database count function DCOUNT to
count the number of cells with specific text.

For instance, in a database of schools, how many schools have electricity
with the options being "HAVE" and "DOESN'T HAVE".

I know I could manually add a column with 1s or 0s to achieve this, but is
there away to do this with text??

Thanks
 

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

Macro to Select text from a point given to a specific word 2
DCount within a Group 2
Using <= in countifs statement 1
Move Chart with Text 0
WORD VBA Search and switch to advanced ... 1
Page numbering with Merged Document and IF statements 1
Using DCOUNT 3
Finding the proper style field and the numbered paragraph value within the style 0

Top