chnage from average to sum(or count)
 

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

chnage from average to sum(or count)
 

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

"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

chnage from average to sum(or count)
 

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

chnage from average to sum(or count)
 

Perfect

"Bob Phillips" wrote:

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

"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