I have a need to calculate the total number of calls for a given time frame on a given date and these calls come in on multiple skillsets. Right now I have a SUMIF statement for each skillset and I need to figure out how to combine these into 1 formula for resource management and my sanity.
Right now it looks like this:
There are 25 of these skillsets so you can see that 25 of these multiplied by 48 time intervals multiplied by 10 clients... the processing power is insane and excel bogs down.Please Login or Register to view this content.
I've tried a couple of things I have found on the internet for using arrays but I'm not having luck. Here is an example of what I need.
So I tried this:Please Login or Register to view this content.
I also tried wrapping each cell reference in " " but it's still not working.Please Login or Register to view this content.
Any help would be appreciated.
Bookmarks