#VALUE when suming multiple cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am exporting a query out of access into excel and if a cell is returning nothing it is just blank as a text, so when I sum the cell with other cells I get a #VALUE
It is usually not an issue as there is 99% numbers in all cells, but when it is blank it errors out
=SUM(A1:A3) would be
A1
A2
A3
but when it is
=SUM(A1:A3) should be 4 but I get #VALU
A1
A2
A3
Any help would be greatly appreciated
 
Hi
is cell A3 in your second example really blank?. SUM should not return
#VALUE in thius case. Maybe cell A3 contains a formula?
 
Not a formula but a blank field coming from an access query output with no return

----- Frank Kabel wrote: ----

H
is cell A3 in your second example really blank?. SUM should not retur
#VALUE in thius case. Maybe cell A3 contains a formula

-
Regard
Frank Kabe
Frankfurt, German


ecat wrote
 
Back
Top