hello,
in column A, i have a list of fruit words.
which formula can count how many times "apple" and "banana" and "orange" are present in column A.
i dont want 3 COUNTIF formulas that are added together. is there simply one formula that checks for all 3?
thank you
Hi ,
Can u provide the Sample Sheet.
Punnam
i dont think theres any need.
column A has many fruit words.
i would like a formula in cell B1 to count the amount of times "apple" and "banana" and "orange" are present
Hi,
=SUM(COUNTIF(A:A,{"apple","orange","banana"}))
Regards
Hi Xor Lx,
Can you brief me about the significance of {} in the formula .
Punnam
It signifies an array constant, i.e. collection of one or more strings, as opposed to an array of cell references.
Regards
Hi Xor Lx
Thankyou
Punnam
You're welcome.Originally Posted by Punnam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks