View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hispeaches hispeaches is offline
external usenet poster
 
Posts: 1
Default IF function question

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!