If you want to see 1 total for the item in column H which might have
more than 1 entry - then I would try the following: Enter the following
in Cell I1 or any other blank cell. Replace the "XXXXXX" what you want
to look for.
This will only work if the cell contains only the "Text" you want to
find, (i.e Apples, it will not work if the cell is "APPLES10")
=SUMIF(H:H,"XXXXXX",D:D).
If you want to "Know what cell contains your text, and have it indicate
it in column I then you can use the following formula - enter into cell
I1 and copy down as far as you need to go.
=IF(H1="XXXXXX",D1)
If it somethin else you might need to give more information of how
Column H is setup and how you want to "Total" Column D.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=508805