Totals

I

Ian.UK

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
 
B

Bob Phillips

=COUNTIF(B:B,"DOG")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top