####### return
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
|