IF function question

  • Thread starter Thread starter hispeaches
  • Start date Start date
H

hispeaches

I have 2 functions on my spreadsheet as follows:

In a column I have
=IF(CURRENT=JAN,B10,)&IF(CURRENT=FEB,C10,)&IF(CURRENT=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(PREVIOUS=MAR,D10,)&IF(PREVIOUS=APR,E10,)&IF(PREVIOUS=MAY,F10,)&IF(PREVIOUS=JUN,G10,)&IF(PREVIOUS=JUL,H10,)&IF(PREVIOUS=AUG,I10,)&IF(PREVIOUS=SEP,J10,)&IF(PREVIOUS=OCT,K10,)&IF(PREVIOUS=NOV,L10,)&IF(PREVIOUS=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
 
Back
Top