hi any help would be appreciated
I'm new to excel formulas so I have no Idea what's going wrong
I am trying to count how many holidays over multiple tables each employee has had
I have put a small example together , but the original has loads more information attached to it
is it possible just to look for the name in any row and then count the amount of holidays in that row.
Last edited by sharky1978; 11-15-2019 at 08:00 AM. Reason: Solved
I suspect that you have oversimplified your raw data too much in your sample... but we'll see:
=SUMPRODUCT(($A$2:$A$17=J5)*($B$2:$F$17="Holiday"))
copied 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
thanks for that its just what I needed,
is there an easy way to add the formula to more table, i.e if I had 52 weeks or do I manually have to put the new formula in for each new table
Just extend the ranges to cover the data
thanks glen ignore my last im still new to this, I understand what to do.
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks