Jan 28 2020 01:57 PM
I am looking to do a sum of a range of cells that are not connected, for example:
=SUM(AD5:AD8+AD14:AD17)
I am getting the #VALUE! warning - Does anyone know what I am doing wrong, or how I would be able to populate the data correctly. TIA.
Jan 28 2020 02:08 PM
@BGaona
That's
=SUM(AD5:AD8,AD14:AD17)
