#value

[ash]

when i am adding up a large range on cells i use this
formula =e13:e376 but it comes up with #VALUE in the cell
but when i add the cells up using the formula
=e13+e14+e15...........+e376 i dont, it gives me the
correct amount!
plase help

 

[Rob Fenn]

I believe the formula should be =SUM(E13:E376)
HTH

 

[Bernard Liengme]

Your first formula should read =SUM(E13:E376)