Forum Discussion
Mumzee
Mar 22, 2022Copper Contributor
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...
harshulz
Mar 22, 2022Iron Contributor
=SUM(COUNTIF(A2:A12,"BANANA")+COUNTIF(A2:A12,"APPLE")+COUNTIF(A2:A12,"GRAPES")+COUNTIF(A2:A12,"KIWI")+COUNTIF(A2:A12,"KIWI"))