I am keeping a spread sheet of our customer base and what medium they learned
about our company from our website to an advertising postcard mailing and
have labeled a column for each after the general name and address
information. I put the number 1 in the appropriate column for counting
purposes. I have taken label of each medium and in the last column created a
tally box for quick reference. I put the formula of =SUM(A2:A17) which works
wonderful. But as I add to the list I am going past 17 and the tally for
those are not counted. Does anyone have a formula that will incorporate the
additional rows into the tally? Also is there a formula that will show the
number of rows so I can show with the tally's an "out of" number?

Thank you kindly for any help.
--
Lisa SW