ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   ####### return (https://www.excelbanter.com/excel-worksheet-functions/212648-return.html)

C.
####### 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.

Niek Otten
####### 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.


Mike H
####### 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.

xlmate[_2_]
####### 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.

C.
####### 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

Niek Otten
####### 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


C.
####### 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.


All times are GMT +1. The time now is 04:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com