Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with SUMPRODUCT
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
Sumproduct using and, and or | Excel Discussion (Misc queries) | |||
Sumproduct again? | Excel Worksheet Functions | |||
SUMPRODUCT except for | New Users to Excel | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions |