#1
|
|||
|
|||
Calculate amount of entered fields
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.
|
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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?
|
#4
|
|||
|
|||
You can do this with sumif, countif, etc.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
calculate date if date entered in cell, do nothing if blank | ConfuddledOne | Excel | 3 | 11-07-2014 09:37 AM |
calculation if either of two fields is entered | BritBiker2 | Excel | 5 | 01-29-2013 09:12 AM |
Calendar Entries Appearing without being entered | billp1955 | Outlook | 2 | 12-31-2012 12:40 PM |
Can entered text automatically appear in 2 different locations? | wordwrkr | Word | 1 | 12-22-2012 12:17 PM |
Print handouts with notes I entered | kennydude | PowerPoint | 2 | 10-16-2012 05:24 AM |