hello
i am a total newb to macros/vb.
my problem is . Weekly I receive a speadsheet in which column H contains
randomly entered words depicting work performed by an individual in different
areas of their work. in column D is the total amount of time taken for that
piece of work.

I wish to search column H for a specific string and then total the
corresponding entry in column d to work out how much time was spent on the
searched for item.
make sense?
can anyone help me with this?
thank you in anticipation.

Hi Adelaide
Try
=SUMIF(Column H,"my word",Column D)
Where Column H is your data range for text
"My Word" is the text string
and Column D is your range to be summed.
You can put this formula any where you like or in a macro

HTH
Michael

"adelaide" wrote:

hello
i am a total newb to macros/vb.
my problem is . Weekly I receive a speadsheet in which column H contains
randomly entered words depicting work performed by an individual in different
areas of their work. in column D is the total amount of time taken for that
piece of work.

I wish to search column H for a specific string and then total the
corresponding entry in column d to work out how much time was spent on the
searched for item.
make sense?
can anyone help me with this?
thank you in anticipation.

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