I need to automate the way a formula is calculated in excel.
Here is the formula that is in excel: =SUM(B3:F3)/5 but if one of these cells is blank then I need it to only divide by the number of cells that is not null.
Any suggestions?
Printable View
I need to automate the way a formula is calculated in excel.
Here is the formula that is in excel: =SUM(B3:F3)/5 but if one of these cells is blank then I need it to only divide by the number of cells that is not null.
Any suggestions?