chnage from average to sum(or count)

[Jim]

Hello,

How do I change this formula to be a sum of all teh entries instead of
average:

=AVERAGE(IF((TEXT(Calls_Received_All!B1:B10000,"mmmyy")=TEXT(D4,"mmmyy"))*(Calls_Received_All!C1:C10000=D2),Calls_Received_All!F1:F10000))

Thank you for the help

 

[Bob Phillips]

Tricky

=SUM(IF((TEXT(Calls_Received_All!B1:B10000,"mmmyy")=TEXT(D4,"mmmyy"))*(Calls_Received_All!C1:C10000=D2),Calls_Received_All!F1:F10000))

 

[Don Guillett]

Have you tried changing average to sum and re-entering as an array formula?

 

[Jim]

Perfect

Tricky

=SUM(IF((TEXT(Calls_Received_All!B1:B10000,"mmmyy")=TEXT(D4,"mmmyy"))*(Calls_Received_All!C1:C10000=D2),Calls_Received_All!F1:F10000))

--
__________________________________
HTH

Bob