Calculate amount of entered fields

[sp1d3r69]

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.

[Pecoflyer]

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?

[sp1d3r69]

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?

[gebobs]

You can do this with sumif, countif, etc.