View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JulieU
 
Posts: n/a
Default Summing one column if two other columns' values appear in other sh

1. One sheet (Sheet1) contains a valid list of task numbers in column A.

2. Another sheet (Sheet2) contains a valid list of people's names in column
A.

3. Another sheet (Sheet3) contains:
a. Task number in column B.
b. Person's name in column D.
c. Number of hours worked in column F.

4. I need to sum the hours worked (Sheet3, column F) if the task number
(Sheet3 column B) appears in Sheet1, column A AND the person's name (Sheet3,
column D) appears in Sheet2, column A. I need the sum to appear in column J
in Sheet2.

Thanks for your help!