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
|