Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Trying to figure something using the subtotaling comand.
Not working for me, obviously!! Bascally we need worry about to colmns. Agent ID, status 1234 Complete 1234 Complete 1234 in-complete what can I do to average colmun be. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
This question is unclear - what is the average of Shane and Devenshire? Do
you want to find the percent Complete if so then a formula such as =COUNTIF(B2:B100,"Complete")/COUNTA(B2:B100) will do it. Then format to %. -- If this helps, please click the Yes button. Cheers, Shane Devenshire " wrote: Trying to figure something using the subtotaling comand. Not working for me, obviously!! Bascally we need worry about to colmns. Agent ID, status 1234 Complete 1234 Complete 1234 in-complete what can I do to average colmun be. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Question regarding averaging | Excel Discussion (Misc queries) | |||
Averaging | Excel Worksheet Functions | |||
Another related question to averaging previous values | Excel Discussion (Misc queries) | |||
Question about averaging | Excel Discussion (Misc queries) | |||
2 part question on averaging | Excel Discussion (Misc queries) |