LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF function question JE Excel Worksheet Functions 1 June 3rd 08 06:40 PM
Function Question SiH23 Excel Discussion (Misc queries) 1 August 12th 07 10:04 PM
IF Function question. Excel beginner Excel Worksheet Functions 0 August 8th 07 10:36 PM
Function question: [email protected] Excel Worksheet Functions 5 March 26th 07 09:26 PM
Function question Dale Rosenthal New Users to Excel 2 January 25th 05 02:10 PM


All times are GMT +1. The time now is 09:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"