User Profile
kdk850
Copper Contributor
Joined Aug 09, 2023
User Widgets
Recent Discussions
Re: How to write a formula to count conditions in a range and then divide the results to get a percentag
mathetes Thanks, I tried both ways and got the nesting to work because I assigned the cells filled in with black with a "1" as I have other cells in the same row that are yellow which I want to count along with the x's =COUNTIF(C71:AF71,"X")/COUNTIF(C71:AF71,"<>"&$BE$2) for the let function, it worked but, it wasn't calculating correctly with the BE2 cell reference, so I had to put the "1" value =LET(xcell,COUNTIF(C71:AF71,"x"),black,COUNTIF(C71:AF71,"<>1"),xcell/black) If I just have a fill color in a cell and want to count by that color without having to put in a value is it possible to do that?1.2KViews0likes1CommentHow to write a formula to count conditions in a range and then divide the results to get a percentag
Not sure if possible, but how would you write a formula in one cell to count a row of cells that aren't filled in as black, then count the cells that have an "X" within that range and then divide the number of cells that have an "X" by the number of cells that aren't filled in as black? I did a workaround and did each function separately in different cells, but wanted to see if it can be done in one function.1.4KViews0likes5Comments
Recent Blog Articles
No content to show