I'm assuming that there's a typo in the Index() formula.
The range is probably C86 to N86.
Then, the formula is to choose one of the 12 cells in the range C86:N86,
dependent on the value of "REPORTPERIOD" minus 1, and return the value in
that cell.
ReportPeriod can be a "named" cell, or even a "named" formula.
Try:
<Insert <Name <Define
And see if there's anything with that name in the box.
Click on the name and see what displays in the 'Refers To' box.
As to the SumIf() formula:
Since you are referencing 2 different size ranges on 2 different sheets, any
changes would be cosmetic.
As to the =+,
It's a holdover from a ex-Lotus user, where formulas in Lotus start with a +
sign, instead of a = sign in XL.
It can be eliminated.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"william4444"
wrote in message
...
Hi all,
Okay i have 3 questions don't now the lot, story of my life.Anyway
1) What does the below mean
=INDEX (C86:N68,REPORTPERIOD-1)
2) Was wondering is there a way i can produce the below Formula a
smarter better way?
=SUMIF('Major Projects'!$A$13:$A$24,'Fin. Perf. (Capex
Resp)'!$B53,'Major Projects'!T$13:T$24)+SUMIF('Major Projects
(2)'!$A$13:$A$27,'Fin. Perf. (Capex Resp)'!$B53,'Major Projects
(2)'!T$13:T$27)
3) What does the + mean in front of =
Eg: i have a formula that has =+
Would appreciate any help hope i explained it okay, have a great day.
Cheers
Will
--
william4444
------------------------------------------------------------------------
william4444's Profile:
http://www.excelforum.com/member.php...o&userid=33991
View this thread: http://www.excelforum.com/showthread...hreadid=537396