Formula to multiply two columns, if a 3rd column contains a certain word?

[Earthpegasus]

I've looked around a lot for this but I can't seem to find anything that matches my exact situation. I'm working with stock exercises, and I want to sum up the amount of stock that was exercised. I have 3 columns: A- price per share, B- quantity exercised, and C- date exercised (which has entries like "november 2017", so I don't have an exact match for "2017").

I'm trying to say "If column C contains "2017", multiply column B by column A." So the formula would start at cell C10, check if it contains "2017," and if it does multiply cell B11*A11. Then do the same for cell C12, etc, all the way to the end. So I'm looking for some combination of sumif, productif, etc, but I just can't quite figure it out. Like a productif formula to give "product(A10:A100,B10:B100) if column C contains the partial text "2017"".

Can anyone help me figure this out? I feel like I'm so close but I just can't get there.

Thank you in advance.

 

[RileyC]

D column
=iferror(find("2017",c#),"-1")
E column
=if(value (d#)<>-1,a#*b#,0)

 

[Eric W]

Welcome to the forum.

Try:

=SUMPRODUCT(A1:A100,B1:B100,--ISNUMBER(FIND(2017,C1:C100)))


HOWEVER: this only works if you have text values in column C. If you have actual date values, it won't work, but is easy to adapt. If you have a mix, it'll be much tougher

 

[Earthpegasus]

Eric W, thanks! That formula was exactly what I was looking for and it worked perfectly.

 

[Eric W]

Glad we could help!