I am not sure it I need to use an if statement or what but I need to return a cell if 2 criteria are true.
What I have is a database with a long list of names and workorder numbers next to the name along with a lot of other data asociated with that person on that workorder. it is possible for one person to do work under different workorders so keep that in mind. on a different tab I have a sheet with a dropdown to select the workorder and then I have a function that brings in all names associated with that workorder. now I need to write a function saying that if this person worked on this workorder return the number of hours he worked on that particular workorder. That information is on the original database tab. I need to do all of this with functions because I am trying to keep it automated for the Administrators that are keying the data.
Would this be a double if statement.
FYI I tried this already:
=SUM(('Mon WS'!E3:E450=Monday!C17)*('Mon WS'!D3:D450=Monday!$D$9)*('Mon WS'!H3:H450))
Here I was trying to do sum((name=name)*(workorder=workorder)*(hours) but it is returning 0. also there may be an instance where I need to return a word and not a value. any help would be great.
Bookmarks