Sum value based on multiple criteria

[ten1jmj]

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"),"")


[TABLE="width: 757"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Carrier
[/TD]
[TD]Revenue Week 1
[/TD]
[TD]Revenue Week 2
[/TD]
[TD]Revenue Week 3
[/TD]
[TD]Revenue Week 4
[/TD]
[TD]Week 1 Date
[/TD]
[TD]Week 2 Date
[/TD]
[TD]Week 3 Date
[/TD]
[TD]Week 4 Date
[/TD]
[TD]Week 5 Date
[/TD]
[/TR]
[TR]
[TD]AA
[/TD]
[TD]abc-50
[/TD]
[TD]50
[/TD]
[TD]90.55
[/TD]
[TD]131.1
[/TD]
[TD]171.65
[/TD]
[TD]12/14/2018
[/TD]
[TD]12/21/2018
[/TD]
[TD]12/28/2018
[/TD]
[TD]1/4/2019
[/TD]
[TD]1/11/2019
[/TD]
[/TR]
[TR]
[TD]BB
[/TD]
[TD]abc-ml
[/TD]
[TD]40
[/TD]
[TD]49.99
[/TD]
[TD]59.98
[/TD]
[TD]
[/TD]
[TD]12/21/2018
[/TD]
[TD]12/28/2018
[/TD]
[TD]1/4/2019
[/TD]
[TD]1/11/2019
[/TD]
[TD]1/18/2019
[/TD]
[/TR]
[TR]
[TD]CC
[/TD]
[TD]def
[/TD]
[TD]35.5
[/TD]
[TD]50
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]12/28/2018
[/TD]
[TD]1/4/2019
[/TD]
[TD]1/11/2019
[/TD]
[TD]1/18/2019
[/TD]
[TD]1/25/2019
[/TD]
[/TR]
[TR]
[TD]DD
[/TD]
[TD]adc-ml
[/TD]
[TD]88.1
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]1/4/2019
[/TD]
[TD]1/11/2019
[/TD]
[TD]1/18/2019
[/TD]
[TD]1/25/2019
[/TD]
[TD]2/1/2019
[/TD]
[/TR]
</tbody>[/TABLE]

 

[ten1jmj]

I'm new to MrExcel so I apologize if I didn't provide enough information in the original post. My goal is to fill in a table similar to the one below as input is added to a master spreadsheet. I've tried adding an additional criteria range and criteria to the formula stated in the original post, in order to specify the "carrier" I need. (I'm wanting to create a similar table for each carrier), but I get a return of #VALUE !.

Again, thank you for providing any assistance possible.

[TABLE="width: 1675"]
<tbody>[TR]
[TD="colspan: 15"]Abc-50
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]Dec-18
[/TD]
[TD]Jan-19
[/TD]
[TD]Feb-19
[/TD]
[TD]Mar-19
[/TD]
[TD]Apr-19
[/TD]
[TD]May-19
[/TD]
[TD]Jun-19
[/TD]
[TD]Jul-19
[/TD]
[TD]Aug-19
[/TD]
[TD]Sep-19
[/TD]
[TD]Oct-19
[/TD]
[TD]Nov-19
[/TD]
[TD]Dec-19
[/TD]
[TD]2019
[/TD]
[/TR]
[TR]
[TD]Average Revenue
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]