Hi everyone,
I am stuck on a formula and was hoping someone could help.
A bit of background of what I need the formula to do.
Each cell within range A2-A21 has either a 'Y' or 'N' in it.
Cell A1 needs to calculate the number of Y's in that range and display either a 0, 1 or 2 depending on
the number of Y's as follows:
Zero Y's = display 0
10 or less Y's = display 1
11-20 Y's = display 2
Appreciate any help
hi aaron85w, try:
=CEILING(COUNTIF(A2:A21,"Y")/10,1)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi
try this:
=IF(COUNT(FIND("y";A2:A21));IF(COUNT(FIND("y";A2:A21))<10;1;IF(COUNT(FIND("y";A2:A21))<20;2));0)
this is an array formula so you have to press CTRL + SHIFT + ENTER when applying the formula.
one more approach..
Formula:
Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Hi Everyone,
I am currently using G18=CEILING(COUNTIF(G19:G24,"Y")/5,1) to count the number of Y's in the range G19:G24. How can I add to this formula to include, if range G:19:G24 is "" then G18 = ""?
Thanks again
maybe:
=IF(COUNTBLANK(G19:G24)=6,"",CEILING(COUNTIF(G19:G24,"Y")/5,1))
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Thanks Benishiryo, works perfect for what I need
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks