Re: match/lookup/find -fuction that returns TRUE/FALSE

From: Aladin Akyurek (akyurek_at_xs4all.nl)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 16:36:57 +0200

=SUMPRODUCT(--ISNUMBER(MATCH(TypeRange,ConditionList,0)),--(YearMonthRange=Y
earMonthCondition),CostRange)

where ConditionList refers to a range that houses 8 types of interest.

"Richard" <anonymous@discussions.microsoft.com> wrote in message
news:2a52901c465a7$121b4f60$a301280a@phx.gbl...
> Hi
> I am looking for a function that matchs an array with an
> text string and return a TRUE/FALSE if found or not.
>
> The background is that I have a very large amount of data.
> The data is contain "Type", "Year/month", "Number of"
> and "Cost".
>
> I have already made some calculations in order to sum the
> cost during a "Year" for this particular "Type". This was
> easy (after a tip from this forum :-) ) by using the
> =SUMPRODUCT-function. Like =SUMPRODUCT((Type=xxx)*(Year=nn)
> *(Cost)).
>
> What I need to do now is to sum the cost per month/year if
> the type is one of 8 particular types.
>
> Does this make any sense??
>
> Hope someone has done something similar and can give me a
> tip!
>
> Best regards
> Richard