Good morning all.
Good stuck with sheet below.
Mainly, sheet contains two workbooks, one "Main", where based on Location( Please note that this should be drop down menu), Designation and date i need to get certain data, and " Manpower", where actually data is.
Tried with "Index/ Match" and "Sumifs", but tough luck...
Thank you
A bit of a guess, as you didn't tell us what you wanted!!:
=SUMIF(Manpower!$F:$F,Main!$C6,Manpower!J:J)
in D6, copied across and down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hello Glenn.
Apologies for not being clear.
All data from workbook "manpower" needs to reflect in " Main" based on drop down menu located in C5 cell.
In row 5 i have numbers like, 1,2,3,ETC which represent for example 01.01.2020, 02.01.2020, 03.01.2020( values for this will be 1 or 0) and then "Hrs" which means how many hours did employee work that day.
So for example, if we select "Location #1" ( cell C5), i need to see values for "design #1" ( This are employee designations) for days and hrs in row 5 ( D5,E5,F5, ETC)
Example:
On "location #1", we have "Design#1" Worked on 1,Hrs 10.5; 2,hrs 10.5; 3,Hrs 10.5; 4,Hrs 12.5; 5,Hrs 11.5; but 6 and 7 was not present
Hope this make it clear
I cant use sumif since in workbook "Main" values need to change in chase where we change location (cell C5)
Then this, maybe:
=SUMIFS(Manpower!J:J,Manpower!$F:$F,Main!$C6,Manpower!$E:$E,Main!$C$5)
copied across and down????
Thank you so much Glenn, this is working now. I have tried Sumifs, but seems that i was doing something wrong.
Thank you once more.
Last edited by AliGW; 12-30-2019 at 07:40 AM. Reason: Please don't quote unnecessarily!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks