| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| 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 | |||
Linear Mode
