G
Guest
I need to show the sum of every 14th cell from S20 to DM20. Some of these
cells will be blank.
The basic SUM formula I am using is:
=SUM(S20+AG20+AU20+BI20+BW20+CK20+CY20+DM20)
Due to some of the cells being blank, I am getting a result of #VALUE!
How can I get it to still show a value, i.e. to still sum the values that
are present?
Thanks
cells will be blank.
The basic SUM formula I am using is:
=SUM(S20+AG20+AU20+BI20+BW20+CK20+CY20+DM20)
Due to some of the cells being blank, I am getting a result of #VALUE!
How can I get it to still show a value, i.e. to still sum the values that
are present?
Thanks