| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif to work with times along a row
I have a spreadsheet where various memebers of staff will enter data in along
a row. Eg A2 their name, B2,C2 upto L2 they enter how much time they have spent on a particular activitity Row 3 would be another person and they list their times across a row. row 4 may be the same person as row 2 etc I need to calcualte how much time a particualr person has spent overall, so I need to find their name then add up their times is columns B to L, works with one column of data, but cannot calculate through the different rows |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumif to work with times along a row
The below formula will find the name 'jacob' in colA and adds up the entries
in column B to L.. Adjust to suit =SUM(INDIRECT("B" & MATCH("jacob",A:A,0) & ":L" & MATCH("jacob",A:A,0))) If this post helps click Yes --------------- Jacob Skaria "gigglygover" wrote: I have a spreadsheet where various memebers of staff will enter data in along a row. Eg A2 their name, B2,C2 upto L2 they enter how much time they have spent on a particular activitity Row 3 would be another person and they list their times across a row. row 4 may be the same person as row 2 etc I need to calcualte how much time a particualr person has spent overall, so I need to find their name then add up their times is columns B to L, works with one column of data, but cannot calculate through the different rows |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumif to work with times along a row
Forgot to mention .. If these are valid time entries in the format 2:00 ....
Format the formula cell to [h]:mm Right clickFormatCellsCustom to display the total time. If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: The below formula will find the name 'jacob' in colA and adds up the entries in column B to L.. Adjust to suit =SUM(INDIRECT("B" & MATCH("jacob",A:A,0) & ":L" & MATCH("jacob",A:A,0))) If this post helps click Yes --------------- Jacob Skaria "gigglygover" wrote: I have a spreadsheet where various memebers of staff will enter data in along a row. Eg A2 their name, B2,C2 upto L2 they enter how much time they have spent on a particular activitity Row 3 would be another person and they list their times across a row. row 4 may be the same person as row 2 etc I need to calcualte how much time a particualr person has spent overall, so I need to find their name then add up their times is columns B to L, works with one column of data, but cannot calculate through the different rows |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I work with lap times? | Excel Discussion (Misc queries) | |||
| Need to work out a timesheet with times going into next day (24 h | Excel Worksheet Functions | |||
| Chart that shows work times | Excel Discussion (Misc queries) | |||
| UDFs return #NAME error sometimes, other times, they work | Excel Discussion (Misc queries) | |||
| The left function does not work when displaying times, how is thi. | Excel Worksheet Functions | |||
Linear Mode
