Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wild card in formula
Greetings all. I am trying to use a SUMPRODUCT formula to calculate a
number, but I need to be able to use * or LIKE, or something with the same results. I have the following, and of course it does not work =SUMPRODUCT((A6:A100 = "*COURSES")*(B6:B100)) I will have several more columns involved once I get this part to work, thus the SUMPRODUCT. Anyhow, I need it to sum B6:B100 where A6:A100 contains the word "courses". I saw another post that kind of did something similar using SEARCH(), but I could not get it to work. Thank you. Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
wild card in SUMPRODUCT formula | Excel Worksheet Functions | |||
how do I use wild card in SUMPRODUCT formula? | Excel Worksheet Functions | |||
wild card?? formula question please | Excel Discussion (Misc queries) | |||
Using wild card in IF formula | Excel Discussion (Misc queries) | |||
wild card -- help with formula | Excel Discussion (Misc queries) |