E-Mail 'Count cells between two values' To A Friend
Email a copy of 'Count cells between two values' to a friend
Loading ... Loading ...5 Responses to “Count cells between two values”
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
How about this array formula?
=ROUND(SUM(MATCH(C12:C13,A1:A10,0)/2),0)
Thank you so much! I've been looking for this everywhere!!
Abby,
Thank you! Remember that the function only works if there are unique values (no duplicates) in the cell range (A1:A10).
hello! thank you so much! this is what i was looking for, but i need some more help if you can. My row data have duplicates, so its not working properly all the time, although every time i know a value that is between those two. Can this formula be adjusted to lookup a value between those two, so it will work?
thanks you again for your help!
Happy new year!
Hello! Thank you so much, do you know if it is possible to choose a range over four columns and two rows? Or is this not possible!