Forum Discussion
Solved
INDEX & MATCH interrupted by Inconsistent Dates
Hello So I have TWO Issues. Issue #1: My formula in columns F(Outbound), G(Inbound), and H(Total) is only working properly for "Jennifer" AND only up until there is a interruption of chronological...
Hi,
The formula you use isn't correct, and some dates in column N are treated as text not as numeric dates.
Please check out the fix in the attached file.
Regards
shade206Performing a match on two conditions like this with an agent and a date whilst returning a numeric value could be done easier with a SUMIFS such as below.
=SUMIFS($O$2:$O$28,$M$2:$M$28,$D$6,$N$2:$N$28,E9)
Alan
shade206What Haytham Amairah mentions on some of the dates being text is also true and needs addressing.
My formula will not work for Kelly whilst their dates are not recognised as one.