That's OK. When a single condition, the conditional becomes:
--(Range=Cond). When there are mo
--ISNUMBER(MATCH(Range,CondList,0)), where CondList is an array like:

{"X","Y","Z"} or a range that houses the conditions like:

X2:Z2

Steved wrote:
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.


--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.