I'm looking for some help on creating a fomula to add up cells on one worksheet to another worksheet. I have a list of names on one work sheet and they are each on a different row. I want to have a formula to add up each of the names to another worksheet. for example on work sheet 1, I would have 5 cells with Tom on them and 12 cells with Bob on them. HOw can I create a formula to add up how many toms and how many bobs there are and continue to add the cells up when adding additonal cells with their names without manually counting the cells? and keep track for which cells are from a date range?

If you need more explanation I can explain further.