Thread
:
excel/ powerpoint2003
View Single Post
#
4
Posted to microsoft.public.excel.misc
Ardus Petus
Posts: n/a
excel/ powerpoint2003
1)
Returns line #REPORTPERIOD-1 from horizontal array C:86:N86.
Probably returns an error .
If you want nth column from array, enter:
=INDEX (C86:N68,1,REPORTPERIOD-1)
2) Your formula is OK. I see no way to improve it
3) the + sign is quite useless, but produces no harm.
Probably an old habit of some Lotus 123 user
HTH
--
AP
"william4444" a
écrit dans le message de news:
...
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
Reply With Quote