I have 2 functions on my spreadsheet as follows:

In a column I have
=IF(CURRENT=JAN,B10,)&IF(CURRENT=FEB,C10,)&IF(CURR ENT=MAR,D10,)&IF(CURRENT=APR,E10,)&IF(CURRENT=MAY, F10,)&IF(CURRENT=JUN,G10,)&IF(CURRENT=JUL,H10,)&IF (CURRENT=AUG,I10,)&IF(CURRENT=SEP,J10,)&IF(CURRENT =OCT,K10,)&IF(CURRENT=NOV,L10,)&IF(CURRENT=DEC,M10 ,)
this total all current months
In the column next to it I have
=IF(PREVIOUS=JAN,B10,)&IF(PREVIOUS=FEB,C10,)&IF(PR EVIOUS=MAR,D10,)&IF(PREVIOUS=APR,E10,)&IF(PREVIOUS =MAY,F10,)&IF(PREVIOUS=JUN,G10,)&IF(PREVIOUS=JUL,H 10,)&IF(PREVIOUS=AUG,I10,)&IF(PREVIOUS=SEP,J10,)&I F(PREVIOUS=OCT,K10,)&IF(PREVIOUS=NOV,L10,)&IF(PREV IOUS=DEC,M10,)
this should total all previous months...

my current is working but my previous total return a REF error. I know it's
something I'm overlooking...

Any help will be greatly appreciated. Thanks!

Are the words CURRENT, PREVIOUS, JAN, FEB, MAR defined as named ranges
or cells? If so, what is PREVIOUS defined as? (Use Insert | Name |
Define to see)

Hope this helps.

Pete



On Jul 11, 3:52*pm, hispeaches
wrote:
I have 2 functions on my spreadsheet as follows:

In a column I have
=IF(CURRENT=JAN,B10,)&IF(CURRENT=FEB,C10,)&IF(CURR ENT=MAR,D10,)&IF(CURRENT=*APR,E10,)&IF(CURRENT=MAY ,F10,)&IF(CURRENT=JUN,G10,)&IF(CURRENT=JUL,H10,)&I F*(CURRENT=AUG,I10,)&IF(CURRENT=SEP,J10,)&IF(CURRE NT=OCT,K10,)&IF(CURRENT=NOV*,L10,)&IF(CURRENT=DEC, M10,)
*this total all current months
In the column next to it I have
=IF(PREVIOUS=JAN,B10,)&IF(PREVIOUS=FEB,C10,)&IF(PR EVIOUS=MAR,D10,)&IF(PREVI*OUS=APR,E10,)&IF(PREVIOU S=MAY,F10,)&IF(PREVIOUS=JUN,G10,)&IF(PREVIOUS=JUL, H*10,)&IF(PREVIOUS=AUG,I10,)&IF(PREVIOUS=SEP,J10,) &IF(PREVIOUS=OCT,K10,)&IF(P*REVIOUS=NOV,L10,)&IF(P REVIOUS=DEC,M10,)
this should total all previous months...

my current is working but my previous total return a REF error. *I know it's
something I'm overlooking...

Any help will be greatly appreciated. *Thanks!