| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a count above average | Excel Worksheet Functions | |||
| need to count/average if... | Excel Worksheet Functions | |||
| chnage date from tuesday 4 January 2005 10:39.26 to 04/01/2005 | Excel Worksheet Functions | |||
| shortcut to chnage color of selected cell in excel? | Excel Worksheet Functions | |||
| Count and then average | Excel Worksheet Functions | |||
Threaded Mode
