software

Who can help me with my issue?

I would like to summarize all fields in the coumn C that apply to given
'text' values in colums A AND B.

I tried VLOOKUP, but this is only applicable to the first value and limited
to two columns

SUMIF is more flexible but I cannot find the formula to first select the row
where both values in column A and B apply and only than the value in the
third column of the same row is added to the values in the next row with the
same match.

=SUMPRODUCT(--(A1:A100=quot;applequot;),--(B1:B100=quot;granny smithquot;),C1:C100)
See www.xldynamic.com/source/xld.SUMPRODUCT.html
explains the quot;--quot;: mcgimpsey.com/excel/formulae/doubleneg.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;JW in Dubaiquot; lt;JW in gt; wrote in message
...
gt; Who can help me with my issue?
gt;
gt; I would like to summarize all fields in the coumn C that apply to given
gt; 'text' values in colums A AND B.
gt;
gt; I tried VLOOKUP, but this is only applicable to the first value and
gt; limited
gt; to two columns
gt;
gt; SUMIF is more flexible but I cannot find the formula to first select the
gt; row
gt; where both values in column A and B apply and only than the value in the
gt; third column of the same row is added to the values in the next row with
gt; the
gt; same match.
i have noticed u r in dubai. if u want advanced help in excel write to :quot;JW in Dubaiquot; wrote:

gt; Who can help me with my issue?
gt;
gt; I would like to summarize all fields in the coumn C that apply to given
gt; 'text' values in colums A AND B.
gt;
gt; I tried VLOOKUP, but this is only applicable to the first value and limited
gt; to two columns
gt;
gt; SUMIF is more flexible but I cannot find the formula to first select the row
gt; where both values in column A and B apply and only than the value in the
gt; third column of the same row is added to the values in the next row with the
gt; same match.