If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
####### return
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. |
Thread Tools | |
Display Modes | |
|
|