####### return

  • Thread starter Thread starter C.
  • Start date Start date
C

C.

Hi all,

When I use the following formula

=SUMIF(Oct08!A$2:A$500,A3,Oct08!P$2:P$500)+
SUMIF(Sept08!A$2:A$500,A3,Sept08!P$2:P$500)+
SUMIF(August08!A$2:A$500,A3,August08!P$2:P$500)+
SUMIF(July08!A$2:A$500,A3,July08!P$2:P$500)+
SUMIF(June08!A$2:A$500,A3,June08!P$2:P$500)+
SUMIF(May08!A$2:A$500,A3,May08!P$2:P$500)+
SUMIF(Apr08!A$2:A$500,A3,Apr08!P$2:P$500)+
SUMIF(Mar08!A$2:A$500,A3,Mar08!P$2:P$500)+
SUMIF(Feb08!A$2:A$500,A3,Feb08!P$2:P$500)+
SUMIF(Jan08!A$2:A$500,A3,Jan08!P$2:P$500)+
SUMIF(Dec07!A$2:A$500,A3,Dec07!P$2:P$500)+
SUMIF(Nov07!A$2:A$500,A3,Nov07!P$2:P$500)+
SUMIF(Oct07!A$2:A$500,A3,Oct07!P$2:P$500)

I get a return of ######

I use this formula on a previous column and it works perfectly. Any
suggestions to why I'm getting this return? Thanks!

C.
 
Hi,

I haven't tried to decipher your formula but as a guess try widening the
column.

Mike
 
####### normally tell you that the result or the length of value return is
too long
for the width of the column.
try to widen the column.

cheers
 
Maybe your formula returnes a negative time/date? You can find out by
formatting as General temporarily.
Negative times can not be pictured in the normal Excel time system. They
can, to some extent, in the 1904 date system: Tools>Options>Calculation tab,
check 1904 date system
Look in HELP to be aware of all the implications

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Hi,

I haven't tried to decipher your formula but as a guess try widening the
column.

Mike
Click to expand...

Tried that, but no dice
 
Maybe your formula returnes a negative time/date? You can find out by
formatting as General temporarily.
Negative times can not be pictured in the normal Excel time system. They
can, to some extent, in the 1904 date system: Tools>Options>Calculation tab,
check 1904 date system
Look in HELP to be aware of all the implications

--
Kind regards,

Niek Otten
Microsoft MVP - Excel





Tried that, but no dice
Click to expand...




Formatting the cells to General did it. Thanks so much!

C.
 
Back
Top