Thank you for any assistance you can give,
I am trying to sum the revenue for each carrier based on the date and get the average for each carrier per month. I have the following formula which nets me the average per month based on all carriers, but I can't figure out how to obtain the results when a specific carrier is desired.
=IFERROR(SUMIFS(Data!$I$2:$P$1048576,Data!$BO$2:$BV$1048576,">="&"12/01/2018",Data!$BO$2:$BV$1048576,"<="&"12/31/2018")/COUNTIFS(Data!$BO$2:$BV$1048576,">="&"12/01/2018",Data!$BO$2:$BV$1048576,"<="&"12/31/2018",Data!$I$2:$P$1048576,">0"),"")
<tbody>
</tbody>
I am trying to sum the revenue for each carrier based on the date and get the average for each carrier per month. I have the following formula which nets me the average per month based on all carriers, but I can't figure out how to obtain the results when a specific carrier is desired.
=IFERROR(SUMIFS(Data!$I$2:$P$1048576,Data!$BO$2:$BV$1048576,">="&"12/01/2018",Data!$BO$2:$BV$1048576,"<="&"12/31/2018")/COUNTIFS(Data!$BO$2:$BV$1048576,">="&"12/01/2018",Data!$BO$2:$BV$1048576,"<="&"12/31/2018",Data!$I$2:$P$1048576,">0"),"")
Name | Carrier | Revenue Week 1 | Revenue Week 2 | Revenue Week 3 | Revenue Week 4 | Week 1 Date | Week 2 Date | Week 3 Date | Week 4 Date | Week 5 Date |
AA | abc-50 | 50 | 90.55 | 131.1 | 171.65 | 12/14/2018 | 12/21/2018 | 12/28/2018 | 1/4/2019 | 1/11/2019 |
BB | abc-ml | 40 | 49.99 | 59.98 | | 12/21/2018 | 12/28/2018 | 1/4/2019 | 1/11/2019 | 1/18/2019 |
CC | def | 35.5 | 50 | | | 12/28/2018 | 1/4/2019 | 1/11/2019 | 1/18/2019 | 1/25/2019 |
DD | adc-ml | 88.1 | | | | 1/4/2019 | 1/11/2019 | 1/18/2019 | 1/25/2019 | 2/1/2019 |
<tbody>
</tbody>