G
Greg Snidow
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
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