Help Please

  • Thread starter Thread starter Alicia
  • Start date Start date
A

Alicia

what formula would I use to make my spreadsheet lookup only certain
data from a spreadsheet and give me the sum. I want to pull only the
sum of hours each forman worked on a different spreadsheet. I might
have 25 Foreman and 150 Welders. Can you help

Name Craft Pay Rate

John Doe Forman 23.99 hr
John Doe Forman 23.99 hr
John Doe Welder 18.32 hr
John Doe Welder 18.32 hr
Jane Doe Admin 15.32 hr
Jane Doe Admin 15.32 hr
 
Suppose the hours worked are in column D on this sheet - put this
formula in your other sheet:

=SUMIF(Sheet1!B:B,"Foreman",Sheet1!D:D)

Hope this helps.

Pete
 
If you have motre than one forman, and only want the numbers from John Doe

=SUMPRODUCT((Sheet1!A1:A15="John
Doe")*(Sheet!B1:B15="Forman")*(Sheet!C1:C15))

Jan
 
Back
Top