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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jim" wrote in message
...
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,"mm myy")=TEXT(D4,"mmmyy"))*(Calls_Received_All!C1:C10 000=D2),Calls_Received_All!F1:F10000))

Thank you for the help