word appearance and totalling

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

Guest

I have 2 words that appear in th same column ORDER and CLOSED. I would like
at the bottom of the spread sheet a total of each word so at the bottm it
says 54 ORDERS and 105 CLOSED. Is this possible and how do I do it?
 
=COUNTIF(<<rage>>,"CLOSED")

=COUNTIF(<<rage>>,"ORDER")

Place the abobe in each cell you wish to get the count for
 

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

problem with fractions to decimal 1
EXCEL FORMULA 5
Macro copy function 1
Microsoft Word 7.0 keyboard delay 1
Change all text on Spread sheet 1
Totaling with "IF" 1
How to avoid Duplicate values .. but want the first value to added in group totals 0
Need your help bad... 2

Back
Top