How do I indicate that I would like to count any time the cell has "DESIGN" in it whether the cell says exactly "DESIGN" or "re-DESIGN"?
Something like this:
=COUNTIFS( range , FIND("DESIGN", UPPER(@cell)) > 0)
where range is likely a column reference. This will also count "design" and "re-design". If you don't need that, remove the UPPER()
Craig
hi J. Craig
How about if I the range is a different sheet and I need to find the number 17 in.
=COUNTIFS({Range 4}, FIND("17", @cell))
or
=COUNTIF(FIND("17", {Range 4}))
Hi everyone! I usually use INDEX/MATCH, but I am trying to "match" multiple criteria and found that it is better to use INDEX/COLLECT when dealing with multiple criteria. I keep returning "#INVALID VALUE" and am confused what I am missing… I have an "Audience" sheet my team is using with employees' respective name, ID…
Hi, I need to count the total number of items that are in progress that are green but I only need it to count the ones where that criteria is met and a checkbox is not checked. I know the formula below works for counting just those in progress and green but I'm struggling to add the checkbox portion to it.…
hi, is there a way that in a form i can have a way to outo populate a section (let say name ) when the fill out their information. Specially if I already have an IF function that does it in the background? For example: if the person adds a specific number it will show am specific name, pulling it from the the IF cell in…