Hello,
I have a report that tracks number of calls that we receive in 15 minute intervals during an entire week. Originally, all of my summary formulas were simple sums that I updated daily. Now, however, I am trying to automate it as much as possible to be able to update it much faster. (A simplified version of the report is attached.)
I ran into a problem when I go to cell J5. Originally, the formula that I tried was:
=sumif($B$214:$V$214,"Mon","Tue","Wed","Thu","Fri",$B248:$P291)
Obviously this didn't work, and I'm not even sure if it makes sense... Essentially, what I am trying to find is this:
When B214 through V214 is Mon, I need the total number of Received (B248:B291), same for Tue through Fri. On Sat and Sun, I need Q and T, respectively, 256-287.
The major problem that I found was that in order to automate this report as much as possible, each cell is linked to another, there are other sheets involved on the full report as well. Since the "Days" in B214-V214 are actually formatted dates and not just string days, I'm not sure how to set the criteria to find the DAY as opposed to the DATE. So although B214 is Mon, it is actually March 1, but I need the formula to look for Mon, not March 1.
Any help will be greatly appreciated :-)
Sonya
Bookmarks