Totals

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

Guest

Hi (again!)

On a similar theme - how do I total up the contents of a column - i.e what
formula could I use to total how many times the word "DOG" appears in column
B of a spreadsheet of pets?

Many thanks,

Ian
 
=COUNTIF(B:B,"DOG")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

Need to Match Multiple Results and Count Text in Different Column 4
Data Consolidation formula 1
Excel Subtracting multiple columns from another column 3
Summing 2
Function neede which checks if a value in a cell is in a defined s 3
ADD 2 COLUMNS USING 1 LETTER AND 1 NUMBER 3
Copy columns, but not hidden ones 3
Help with data total 3

Back
Top