Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF function question | Excel Worksheet Functions | |||
Function Question | Excel Discussion (Misc queries) | |||
IF Function question. | Excel Worksheet Functions | |||
Function question: | Excel Worksheet Functions | |||
Function question | New Users to Excel |