Formula Needed
Closed
boderek
-
21 Feb 2012 à 09:53
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 23 Feb 2012 à 08:41
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 23 Feb 2012 à 08:41
Related:
- Formula Needed
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Spreadsheet formula - Guide
- Grade formula in excel marksheet - Guide
- Credit summation formula - Guide
- Formula to calculate vat in excel - Guide
3 responses
Thought I'd try to make my question a bit clearer
Hi - needing some help with a formula - I have several columns taken from sage data. I have in one column employees hours (A) and another employees name(D), as you can see sometimes employees name appears more than once. what I am needing is in another row is employee name who was working on the job to appear and all their hours beside their name. Would be greatful for your help
A B C D
hours rate cost employee
13.5 £8.00 £108.00 SMITH
0.5 £6.85 £3.43 JONES
0.5 £6.85 £3.43 JONES
1.5 £6.75 £10.13 SMITH
1 £6.75 £6.75 SMITH
17 £131.74
employee total hours
SMITH 16
JONES 1
Hi - needing some help with a formula - I have several columns taken from sage data. I have in one column employees hours (A) and another employees name(D), as you can see sometimes employees name appears more than once. what I am needing is in another row is employee name who was working on the job to appear and all their hours beside their name. Would be greatful for your help
A B C D
hours rate cost employee
13.5 £8.00 £108.00 SMITH
0.5 £6.85 £3.43 JONES
0.5 £6.85 £3.43 JONES
1.5 £6.75 £10.13 SMITH
1 £6.75 £6.75 SMITH
17 £131.74
employee total hours
SMITH 16
JONES 1
RWomanizer
Posts
365
Registration date
Monday 7 February 2011
Status
Contributor
Last seen
30 September 2013
120
23 Feb 2012 à 05:38
23 Feb 2012 à 05:38
Use pivot table,
drag employee name in row label and total hours in values.
drag employee name in row label and total hours in values.
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
23 Feb 2012 à 08:41
23 Feb 2012 à 08:41
Hi Boderek,
Try using an array formula.
Your given table:
13.5 £8.00 £108.00 SMITH
0.5 £6.85 £3.43 JONES
0.5 £6.85 £3.43 JONES
1.5 £6.75 £10.13 SMITH
1 £6.75 £6.75 SMITH
Is located in range A1:D5.
Then use the following formula anywhere on the sheet:
=SUM(($D$1:$D$5="SMITH")*($A$1:$A$5))
An array formula needs to be confirmed by hitting Ctrl+Shift+Enter.
Doing this correctly will enclose the formula in curly brackets.
Now drag the formula down and change the name SMITH into another. Don't forget to confirm as described above.
Best regards,
Trowa
Try using an array formula.
Your given table:
13.5 £8.00 £108.00 SMITH
0.5 £6.85 £3.43 JONES
0.5 £6.85 £3.43 JONES
1.5 £6.75 £10.13 SMITH
1 £6.75 £6.75 SMITH
Is located in range A1:D5.
Then use the following formula anywhere on the sheet:
=SUM(($D$1:$D$5="SMITH")*($A$1:$A$5))
An array formula needs to be confirmed by hitting Ctrl+Shift+Enter.
Doing this correctly will enclose the formula in curly brackets.
Now drag the formula down and change the name SMITH into another. Don't forget to confirm as described above.
Best regards,
Trowa
23 Feb 2012 à 04:53
column A hours
Column B hours
Column C Costs
Column D Employee
Want to search column A & D then list Employee name and total hours for that employee.
Hope this is a bit clearer???
Thanks