Hi,
i would like to calculate total counts of cell in a row containing symbol @. i used =Countif(Range,"@*"). But this did not give me result. much appreciated, if anyone can help
Regards,
Karthik
Hi,
i would like to calculate total counts of cell in a row containing symbol @. i used =Countif(Range,"@*"). But this did not give me result. much appreciated, if anyone can help
Regards,
Karthik
Say your range is A1:A25, then
Hope this helps.![]()
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Sorry I forgot to tell you that the formula above is an array formula, so you need to confirm it by Ctrl+Shift+Enter.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks