Hello,
An internal program exports in a way that I'm finding is difficult to work with. I have limited Excel experience but it seems like using SUMIF isn't working.
Basically, I have a timeline that shows a count of how many people were out based on their code reason. For example, the timeline shows that at 13:00 1 person was a lunch and 3 people were on break - I need to know that during that time 4 people were out.
Excel Help1.xlsx
Seems simple but I'm struggling..
What I was trying is: =SUMIF($A$4:$A$8,OR("LUNCH","BREAK"),N$4:N$8)
but it's not summing anything.. just getting 0s.
I have to do this for 45 columns into 10 groups so there's gotta be an easier way.
Wouldn't mind using a macro but I didn't want to start before getting any formula to work.
Thank you for any help/suggestions/pointers!
Bookmarks