I want to try to make a formula that will read what is on Main2, read if it has the specific text in it, then extract the number. And add those numbers together.
Do I need to use REGEXREPLACE? I’ve never heard of that and I’m having trouble learning it.
So for the example in there, I want it to scan everything on Main2 and see if it has the words “Chuchu Jelly” in it. If it does then I want it to extract the digits and then add all the digits up. The adding them up part doesn’t sound complicated but I don’t know how to do the rest.