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. |
#2
|
|||
|
|||
####### 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. |
#3
|
|||
|
|||
####### return
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. |
#4
|
|||
|
|||
####### return
####### 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 "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. |
#5
|
|||
|
|||
####### 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 |
#6
|
|||
|
|||
####### return
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 |
#7
|
|||
|
|||
####### 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. |
Thread Tools | |
Display Modes | |
|
|