Hi to all,
I have a range of cell H15:BE15. Each cell has a numeric value in it (a number between 1 and 100).
I need to count the number of some cells that has values less than 50.
In specific, I need to count the numbers < 50 in the following columns only: L , Q , V , AA , AF , AK , AP , AU , AZ , BE
How can this be done ?
Khalil
Onw way:
=SUM(COUNTIF(INDIRECT({"L15","Q15","V15","AA15","AF15","AK15","AP15","AU15","AU15","AZ15","BE15"}),"<50"))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you very much.
The exact result was accomplished
Hi,
I tried to copy it to the lines below but was not successful.
What adjustments should be done to copy it to the lines below?
You didn't ask for that, did you?? Back in a moment or two.
Yes, you are right, I did not ask for that, I though it will copy as I used to do using dragging or copy and paste.
I just noticed that there was a pattern to it... not random columns. Use this:
=SUMPRODUCT((MOD(COLUMN(L15:BE15)-COLUMN(L15),5)=0)*(L15:BE15<50))
Thank you very much
You're welcome.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks