Help with finding an average with Sumproduct

This formula

=SUMPRODUCT((Data!$U$6:$U$2076=$B$13)*(Data!$G$6:$G$2076="EM-A-DOWN")*(MONTH(Data!$B$6:$B$2076)=E$14))

Counts the rows were the text "SB" is in column U, "EM-A-Down" is in column G, and the date in E14 is found in column B on the Data sheet.

In the attached example, Critical Calls for May was 5

What I need next is to find the average response time for those 5 critical calls, The response time data is found in column R on the "Data" Tab

Is this possible?

Thanks in Advance!!






New Fransican Con-Call Report.xlsm

Average = SUM divided by COUNT

You already have the count, with that formula.
You can get the SUM by adding column R to the formula
=SUMPRODUCT((Data!$U$6:$U$2076=$B$13)*(Data!$G$6:$G$2076="EM-A-DOWN")*(MONTH(Data!$B$6:$B$2076)=E$14)*Data!$R$6:$R$2076)

I'd like to think that in the overall scheme you want to keep all 3 values, the count, the sum, and the average.
So say A1 contains the count, A2 contains the Sum, then in A3 to get the average is just =A2/A1

Thank you both for helping clear my head!

You're welcome.