I run a doggie daycare, boarding & grooming facility. I keep tabs of each
days activities for each dog. For example, on 4/1/07 Fido comes in for
daycare (D), gets a pedicure (P), and is fed (F). Spot comes in for a bath
(S) and board (B). I have dates running across the top (columns) and dogs
running down the left (rows). Each day I run a total of all the Ds, Ps,
Bs, etc. Formula: €œ=SUM(COUNTIF(B2:B8,€�=*B*€�))
Im not sure thats the right way to do the formula, but its working.
At the end of the month I want to run a total on all of the services Fido
received. My question is, how do I write that formula? Using the formula
above and changing the cell IDs didnt work.

--
Valerie