| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
COUNT ONLY CELLS THAT AREN'T BLANK
This is the present function I have to get an average of $D$4:$D$3710:
=(SUMIF($A$4:$A$3710,A3742,$D$4:$D$3710))/(COUNTIF($A$4:$A$3710,A3742) The problem with this is that it is counting all cells in $A$4:$A$3710 that equal A3742. To get a correct average I need to only count cells that are not blank in $D$4:$D$3710 based on $A$4:$A$3710 equalling A3742. Can anyone help me with this? -- PaulineC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
| how to skip the blank cells | Excel Discussion (Misc queries) | |||
| Automatic copying data excluding blank cells | Excel Worksheet Functions | |||
Threaded Mode
