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

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

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