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!