RE: LOOKUP on multiple conditions

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanx Jacob,

But sum is not required. It Column D may have numerical ast well as text
entries.
--
Do check "Yes" if this post is helpful,
Best Regards,

Faraz


"Jacob Skaria" wrote:

If you dont have duplicates the below will return the entry in Col C greater
than 10,000. If there are more entries above 10,000 the below will return the
sum

=SUMPRODUCT(--(A1:A100="A"),--(B1:B100="X"),--(C1:C100>10000),C1:C100)

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

Can one of you kindly devise me a formula/UDF for me so as to apply the
V/HLOOKUP on multiple conditions without creating a helper column?

For instance returning the column D's entry where Column A's entry has "A"
and Column B's entry is "X" and Value in Column C is greater than 10,000?

Thanx in advance.

--
Best Regards,

Faraz
.

Relevant Pages

  • Re: Help with creating a formula
    ... Your using the term SUM when what you really want is a COUNT. ... Each of these expressions will return an array of either TRUE or FALSE: ... up entries in column A that had an "H", but only if the entry in column B ...
    (microsoft.public.excel.worksheet.functions)
  • RE: LOOKUP on multiple conditions
    ... "Faraz A. Qureshi" wrote: ... But sum is not required. ... "Jacob Skaria" wrote: ... For instance returning the column D's entry where Column A's entry has "A" ...
    (microsoft.public.excel.misc)
  • RE: Help with creating a formula
    ... multiplying the sum of criteria in each column together vs. looking at there ... relationship to one another and summing up the entries for one column. ... up entries in column A that had an "H", but only if the entry in column B had ... I am trying to create a formula that will sum up certain criteria from one ...
    (microsoft.public.excel.worksheet.functions)
  • RE: LOOKUP on multiple conditions
    ... If you have text entries modify that to... ... "Jacob Skaria" wrote: ... But sum is not required. ... For instance returning the column D's entry where Column A's entry has "A" ...
    (microsoft.public.excel.misc)
  • RE: SumIf by Date?
    ... The below will return the sum of values in ColB for all date entries in Col A ... Jacob Skaria ... I have several large ongoing database, and would like to sum sales figures ...
    (microsoft.public.excel.misc)