####### return
On Dec 5, 3:21*pm, "Niek Otten" wrote:
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: ToolsOptionsCalculation tab,
check 1904 date system
Look in HELP to be aware of all the implications
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"C." wrote in message
...
On Dec 5, 2:57 pm, Mike H wrote:
Hi,
I haven't tried to decipher your formula but as a guess try widening the
column.
Mike
"C." wrote:
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.
Tried that, but no dice
Formatting the cells to General did it. Thanks so much!
C.
|