Hello Aladin from Steved
{"Papakura","Wiri"},0))
If you look at the above you will see that it'll add column Papakura+Wiri
so I thought to myself I will put {"Contract Kilometres(Manuals)","Contract
Kilometres(Manuals)"} in to remind me how to add columns with Names. It might
look silly but it comes down to a Learning process for me.
Well that's my thinking on this issue.
Cheers.
"Aladin Akyurek" wrote:
Why does this
{"Contract Kilometres(Manuals)","Contract Kilometres(Manuals)"}
lists the same item twice?
Steved wrote:
Hello from Steved
=SUMPRODUCT(--ISNUMBER(MATCH('From Charters'!$F$1:$F$898,{"Contract
Kilometres(Manuals)","Contract Kilometres(Manuals)"},0)),--('From
Charters'!$B$1:$B$898="Period.4"),'From Charters'!$I$1:$I$898)
from this 'From Charters'!$I$1:$I$898) to'From Charters'!$I$1:$J$898)
gives a #VALUE!.
Basically i'm trying to sum 2 cells Charters'!$I$1:$I$898 and
Charters'!$J$1:$J$898
Thankyou.
|