| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom formatting
I have a gradebook that contains "-" representing assignments earning 0
points because they weren't turned in, and 0 representing assignments earning 0 points that were turned in. How can I continue to view the "-", while making it worth 0 points in calculation of average, median, etc.? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
custom formatting
One way:
Average: =SUM(A1:A10)/COUNTA(A1:A10) Median (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN): =MEDIAN(IF(A1:A10="-",0,IF(A1:A10<"",A1:A10))) In article , Nuhuskr7 wrote: I have a gradebook that contains "-" representing assignments earning 0 points because they weren't turned in, and 0 representing assignments earning 0 points that were turned in. How can I continue to view the "-", while making it worth 0 points in calculation of average, median, etc.? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Formatting | Excel Discussion (Misc queries) | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
| Custom Formatting | Excel Discussion (Misc queries) | |||
| Custom Formatting | Excel Discussion (Misc queries) | |||
| Custom formatting | Excel Discussion (Misc queries) | |||
Linear Mode
