Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi all
let say I have the following row of information 112 98 empty 123 99 empty empty 99 100 120 Now I want to add the row and divide it by the full cells (no empty) the result beeing an average (751 / 7 = 107,29) How can I do this? Tia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
When I SUM cells & 1 is empty I need the result to be empty not 0 | Excel Discussion (Misc queries) | |||
how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
Macro to copy value in empty cells | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) |