IF function question

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!
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top