Mar 21 2022 06:31 PM
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!
Mar 21 2022 07:04 PM
Mar 21 2022 07:56 PM
thank you I will try 1st as sure 2nd choice is what I was trying but kept giving me error.
will post tomorrow results
and will try both just to see
🥰
Mar 21 2022 08:02 PM
=SUM(COUNTIF(A2:A12,"BANANA")+COUNTIF(A2:A12,"APPLE")+COUNTIF(A2:A12,"GRAPES")+COUNTIF(A2:A12,"KIWI")+COUNTIF(A2:A12,"KIWI"))
Mar 22 2022 02:54 AM
Mar 27 2022 11:44 AM