Dec 13 2020 01:52 PM
Trying to use a sum Function to total several cells in a row. If any cells are empty, I get a #VALUE! error.
Dec 13 2020 02:07 PM - edited Dec 13 2020 02:07 PM
K2 ist not empty.
SUM(F2,G2,K2,M2,O2,P2)
And you should set formula calculation to 'automatic'.