If statement outcome problem

[devilchild99]

Hi there,

First off thanks for even reading.
What I am trying to do is a multiple If ... I think. I will try and explain
=IF(C1=Data!A:A,IF(A4=Data!C:C,IF(B2=Data!B:B,Data!D2,0))) is what I put together. I put together a small sample excel to try and get this to work.
What it is i have 3 sheets. One Named data where the info goes, one sheet named Tim and other sheet named Tom.
On data sheet there is 5 sections one for Name, Location, Date, # of people, hours.
So what I am trying to do is
get the value of # of people and hours based on if its Tim or Toms name and if the date match and by location.
I attached the sample I am working with, also left my code on Tim's sheet in cell b4.
So if the name matches Tim and the date and the location insert # of hours.
testing.xlsx
I am open to suggestions for better methods if there is any.

Thanks for your time and help, hope I explained good enough for help.

[FDibbins]

Thanks for the title change

Try this, copied down...
=SUMIFS(Data!$D$2:$D$4,Data!$A$2:$A$4,Tim!$C$1,Data!$C$2:$C$4,Tim!$A4,Data!$B$2:$B$4,Tim!$B$2)
Adjust ranges as needed for hours

[devilchild99]

That seems to work, thank you so much.

[devilchild99]

disregard, thanks