Hi, I am currently drawing up a spreadsheet to calculate a hired engineers jobs. I have broken it down into months in worksheets and I need to know how much he has spent on parts (easy enough) but I need a total to know how many jobs he has done. Is there a formula to calculate or add 1 everytime he fills in a row? Thanks in advance.

Do you really need different worksheets? It's often easier to have one long list ( with for example a month column) which will permit easy data extracting and analyze?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I know what you're saying but I have a 'totals' worksheet also and need a total of repair costs and total jobs done calculation so that it's easy for me to see how much my monthly invoice is as I'm paying him a set amount for every job done. Or...if I do one long sheet how do I calculate jobs done in @'january', 'February', etc?

You can do this with sumif, countif, etc.