Sum one column based on numerous text values in another

[RodneyC]

In cell D4 of a tab named ALL I need a formula that will look in a tab named WO and sum all the values on M3:M86114 if and only if the values in J3:J86114 include the text Green Peas. For clarity, the values may be Green Peas Boiled or Green Peas Fried or Green Peas Steamed. I need to include everything Green Peas.

Here's where I've started

=SUMIFS(WO!M3:M86114,WO!J3:J86114 but I have no idea where to go from here.

ALSO since the data will change each month, therefore the number of lines will change, I can use M:M and J:J and not reference line numbers?

Thank you in advance

 

[RoryA]

You can use:

=SUMIFS(WO!M:M,WO!J:J,"*green peas*")

 

[Fluff]

How about

=SUMIFS(WO!M:M,WO!J:J,"Green Peas*")

 

[RodneyC]

DANG! You guys are good and quick. I took what Rory did since it was first in line and it worked. Thank you all

 

[Fluff]

Glad we could help & thanks for the feedback.

FYI Rory's will find anything that contains Green peas, whilst mine will only find cells that start with Green peas.