Need help with SUMPRODUCT
I also need to make the A:A and D:D static when I copy across cells...
I thought A$:A$ would work?
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 -
|