####### return
Widen the column
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"C." wrote in message
...
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.
|