So what about for your next COUNTIF value, say it is one down, like >=11, that you want to solve for? I was able to use the formula for a value of "5", but once I tried to use the same formula in a cell below that, for the value of "4," it combined the percentages for both "5" and "4". So your formula helped me figure out for "5" that calculated to 81%, whereas "4" should have calculated to 12%, it added "5" and "4" and gave me back 93%.
hi sir am see your video is so interesting but i have some question can you help to explain - i want to countfi (Text with condition ) by Ignore hiding row it look the same your video but your video is number and how about text can count or not ? Regarding, KenKiller
come on man...at least paste the formula somewhere to be easily copied lol So much effort into the video and like...that's just a small detail that helps everyone from having to look at the hideous 3 array formula.
Thanks man ... I think this is only relevant and true video on TH-cam for this specific problem ...love u man
I've been spending a few hours on how to do this, and it only took me 4 mins to learn it from this tutorial! This is awesome!! Thank you for sharing!!
AWESOME explanation! Thanks for sharing what each part of the formula is doing!
Bro! That was an amazing thought process… Just realised that we could use the Sumproduct so effectively…
This video was really good, helped sort something I didn't think was possible. Thank you
Man, you helped me solved a huge problem I had, thank you soo much!!
Thank you so much it is help me allot
, I have a question ( How to input the BETWEEN values ? )
Thank u, I found the way
Thanks Brother!! this helped me a lot!!
So what about for your next COUNTIF value, say it is one down, like >=11, that you want to solve for? I was able to use the formula for a value of "5", but once I tried to use the same formula in a cell below that, for the value of "4," it combined the percentages for both "5" and "4". So your formula helped me figure out for "5" that calculated to 81%, whereas "4" should have calculated to 12%, it added "5" and "4" and gave me back 93%.
hi sir am see your video is so interesting but i have some question can you help to explain
- i want to countfi (Text with condition ) by Ignore hiding row it look the same your video but your video is number and how about text can count or not ?
Regarding,
KenKiller
nice , thanks for share
come on man...at least paste the formula somewhere to be easily copied lol So much effort into the video and like...that's just a small detail that helps everyone from having to look at the hideous 3 array formula.
=SUMPRODUCT(SUBTOTAL(3,OFFSET(C:C,ROW(C:C)-MIN(ROW(C:C)),,1)),--(C:C=5))
@@fresho67 thx mate. some pc using ; rather than ,
awesome