Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
####### 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
####### 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
####### 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
####### 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
####### 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
####### 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
####### 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MAX then return value? | Excel Discussion (Misc queries) | |||
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
return value other than #N/A | Excel Worksheet Functions | |||
check if reference exists, then return its value or return 0 | Excel Worksheet Functions |