Hello all.
I have a formula that is written like this:
countifs(a6:q6,z6) Z6 has >=1%. I also have the 1% in cell w6, which is used for other things.
My question is the percentage will be changing on a regular basis. How can I write the greater than formula to reference W6 and still have the countifs still function?
Thank you in advance for any help that can be provided.
Last edited by pboost1; 05-31-2018 at 12:18 PM.
countifs(a6:q6,">"&W6)
Thw formula references W6 and COUNTIF still functions.
If this is not what you want then you need to explain more clearly.
Last edited by Special-K; 05-31-2018 at 11:52 AM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Perhaps
=COUNTIF(A6:Q6,">="&W6)
I would like to count all the cells between a6 and q6 that are greater than 1%.
I have the 1% in cell w6, and that will change on a regular basis.
Thank you Jason.b75. your formula seems to work. are you able to explain why the quotes and the &.
if you want it to refer to W6 and greater than 1% and 1% is coded into W6 then =COUNTIF(A6:Q6,">"&W6)
should do it for you.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
for an explanation of the quotes and ampersand
https://www.excelforum.com/excel-gen...t-formula.html
see posts #2 and #3.
That is just a way of joining text to the content of a cell, ">="&W6 is the same as >=W6, but COUNTIF, SUMIF, etc don't like it if you use the shorter version.Originally Posted by pboost1
Thank you for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks