I have an Excell work book that contans a number of work sheets with a number
of employees names listed in column "B" and amounts to pay each name in
adjacent column "C". An employee's name is located a number of times in one
column of each work sheet in no corresponding order. ie.. an employee may be
in cells B5, B7and B10 with amounts owing in adjacent cells in column C5, C7
and C10, on one particular sheet and on another sheet may be positioned with
other employees,in B1, B2, B9, B10 and B11, again with adjactent column C
having amounts of monies owed. Is there a way to automatically select an
employees name once from relavent columns from each sheet in work book and
accumulate all amounts of monies in adjacent cells to represent one total
owing to that one employee.

Hi,

Suppose you want to put the total in Sheet1!B1 with their name in cell A1 of
that same sheet, while the info is on Sheet2 and Sheet3, then your formula
would be:

=SUMIF(Sheet2!B1:B100,A1,Sheet2!C1:C100)+SUMIF(She et3!B1:B100,A1,Sheet3!C1:C100)


If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"ampe" wrote:

I have an Excell work book that contans a number of work sheets with a number
of employees names listed in column "B" and amounts to pay each name in
adjacent column "C". An employee's name is located a number of times in one
column of each work sheet in no corresponding order. ie.. an employee may be
in cells B5, B7and B10 with amounts owing in adjacent cells in column C5, C7
and C10, on one particular sheet and on another sheet may be positioned with
other employees,in B1, B2, B9, B10 and B11, again with adjactent column C
having amounts of monies owed. Is there a way to automatically select an
employees name once from relavent columns from each sheet in work book and
accumulate all amounts of monies in adjacent cells to represent one total
owing to that one employee.