Maybe...

=SUMIF(INDIRECT("'"&$X$1&"'!A:A"),"*"&A3&"*",INDIR ECT("'"&$X$1&"'!D:D"))

Change $x$1 to the address that contains the name of the worksheet.


Livin wrote:

COOL!

So I now have...

=SUMIF(US!A:A,"*"&A3&"*",US!D:D)

how do I convert the US into a value from a cell?

this value will change depending on the column and I want to use the
column header for the value.

thanks!

On Aug 18, 2:59 pm, "Peo Sjoblom" wrote:
=SUMIF(A:A,"*Norton*",B:B)

--

Regards,

Peo Sjoblom

"Livin" wrote in message

...



situation...

ColA ColD

Norton AV 78
Norton Suite 12
Norton Spy 34
Norton Anti-Virus 56

Search each row in ColA, if contains "Norton", add value from ColD to
the SUM.

What I have so far, but it is adding ecerything in ColD, even if it
does not contain "Norton"
In this case, A3 is the value "Norton", and US is the sheet name it is
searching.

=SUMPRODUCT(--(IF(ISNUMBER(SEARCH(A3,US!A:A)),US!D:D)))

thx in advance!- Hide quoted text -

- Show quoted text -

--

Dave Peterson