I need to count all "S" in sheet PER, with the criteria being the month in sheet KAM (month number is in Row1) AND the correct Location ie. LOC1
In sheet KAM I need to see how many "S" each location has in each month. (Yes it begins with 7/juli)
http://www.excelforum.com/attachment...1&d=1470598724
Something like...
InvalidTxtString-count-b-ugly.xlsx
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
In C4 of "KAM"
=SUMPRODUCT((Per!$J$3:$NJ$36="s")*(Per!$A$3:$A$36=KAM!$B3)*(MONTH(Per!$J$2:$NJ$2)=KAM!C$1))
Copy across and down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks