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
|