Forum Discussion
Going bananas trying to create a way to count multiple names in a column
Have a simple spreadsheet in one column I have a bunch of fruit names about 30 different ones total input in about 250 rows trying to do a count if 5 separate names to amount to the number 5 n a ce...
the simplest way (conceptually) is
=countif(d2:d250,”apple”)+countif(d2:d250, “orange”)+countif(d2:d250,“lemon”)+countif(d2:d250,“green grape”)
another option using arrays is:
=sum(countif(d2:d250,{”apple”, “orange”, “lemon”, “green grape”}))
=countif(d2:d250,”apple”)+countif(d2:d250, “orange”)+countif(d2:d250,“lemon”)+countif(d2:d250,“green grape”)
another option using arrays is:
=sum(countif(d2:d250,{”apple”, “orange”, “lemon”, “green grape”}))
