Deepak,

I'm not sure what those named ranges refer to. Can you provide more
details using exact refernces?

agarwaldvk wrote:
Aladin

That's great! I now understand!

Two, what about the last bit of my query where the single cell instead
of being specified as A1 gets referred to by the use of the combination
of the 'Index() and the Match() functions like so :-

{=sum(sumif(INDEX(Index_200407_NSW,MATCH(TRIM($A9)
,TRIM(MatchCol_200407_NSW),0),1)), "<0", "0", "0"))} - formula being
array entered!


Any clues on this????????


Best regards



Deepak Agarwal



--

[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.