SUMIFS with multiple Criteria

[mmode66]

I'm trying to sum data based on a phone time for a person between two dates.
I'm returning a blank value in the cell currently and can't figure out why. I've watched multiple videos to find a solution and i must be missing something.



Formula: =IFERROR(SUMIFS(DATA!$BG:$BG,DATA!$E:$E,">="&$C$1,DATA!$E:$E,"<="&$AM$1,DATA!$A:$A,"="&A3),"")

DATA!BG:BG = Phone time
DATA!E:E = Date column
C = First Date
AM = Last Date
DATA!A:A = Name range
A3 = Name

 

[bbotzong]

First, it's a bit hard to debug a formula without source data. Is there sample data you can post?

Second, I found that working with cumulative time requires a special format for the hours field. Normally, time is formatted h:mm:ss. This format will accumulate total hours over 24 into days. For the project I was working on, this wasn't what I needed. If you use the custom format [h]:mm:ss, then the 24-hour roll-over is no longer active. You can accumulate all the time value you want and it will just show hours.

 

[mmode66]

I'm taking all phone time for an Advisor between a date range and adding it together. The tracker i've built sort's 1 week at a time. In the top corner they can place a date and the next 7 days will fill in.
At the end is the "Weekly" data which has required me to grab dates into the formula so when they change weeks it's accurate. Currently it's just a basic sumif on the advisor and the stat for all data.
I don't have an hours field, only dates.

Example: I need Jen's car sales between 5/20/2019 and 5/27/2019. Basically the same principle Im trying to accomplish.
Maybe my formula isn't the right one for this type of task?