Automatic recalculation

**KalEl** · 01-03-2012, 12:29 PM

Hello guys,
pls could anyone give me a tip/hint how to achieve this:

I have a timesheet/charge table where I have these units for every employee: worked hours / rate per hour (2 different ones) & the sum of these two.

I have a pre-given total financial sum (detailed up to decimal numbers) that I have to achieve between these two units.

Is there any way to program the Excel 2010 table that way that it automatically recounts the numbers in the unit field mentioned above so that they would match/give the total financial sum?

Thanks a lot for the help upfront

**dilipandey** · 01-03-2012, 01:39 PM

Hi KaIEI,

Please post a sample file. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**arlu1201** · 01-03-2012, 02:05 PM

I guess it would be good if you attach a sample workbook.

**KalEl** · 01-04-2012, 05:27 AM

Hello,
thx for your kind help upfront. Here's a link for the sample workbook:

https://docs.google.com/spreadsheet/...2JCX3QxZDBYb2c

**arlu1201** · 01-04-2012, 05:49 AM

If i understand you right, you are looking at multiplying the Hours * charge for each employee and to give you the value in column D. Then you would need a total sum for each employee based on the number of occurrences per employee, right?

**KalEl** · 01-04-2012, 05:52 AM

That's correct. My aim is to calculate it in a way so that it gives the total sum at the foot of column D. Not sure it is entirely possible though. Coming close to the total sum number would help as well.

**arlu1201** · 01-04-2012, 06:05 AM

Why would you have a problem in getting the total sum at the foot of column D? You just have to sum it like any other summation you would do.

**KalEl** · 01-04-2012, 06:10 AM

Understand, but I meant not getting it as per se, but getting a certain fixed number.

**arlu1201** · 01-04-2012, 06:16 AM

Sorry, but I am still not able to understand your query. Maybe you can try with some example.

**anandvh** · 01-04-2012, 05:03 PM

If I understand your query correctly, you want the total of hours and total sum charged for each employee as well as the grand total for all employees. The simplest way is to use the subtotal feature under the Data menu. You only have to make sure that the employee name against each entry and sort the table employee-wise before applying the subtotal feature.