Hi,
I am trying to put a formula into a spreadsheet that will do the following:

Look up names in one sheet and count the number of times it appears then put this information into another sheet.

I think I need an if function but am not sure where to start

Any help would be much appreciated