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 cell n a different column
have tried =countif(d2:d250”apple”, “orange”, “lemon”, “green grape”)
=sumcountifs(d2:d250{apple”, “orange”, “lemon”, “green grape”})
but no luck
please, can someone help me!
5 Replies
- Thank you everyone. All worked out as needed 😍
- 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”}))
