I am trying to create a "% complete" chart where the column on the lefts reads to right. I need it looks for the value of "x" in a cell within the row to the right and then report the % number in the header above it. I am using the xlookup and got it to report the % complete. I'm not to familiar xlookup, so maybe there is a better way. I have rows I need to keep but need them to not to report 0% or 100% as this will affect the "Overall % Complete" when it counts them. How do I get the % Complete to read on the Percentage?
=XLOOKUP("x",H31:CN31,$H$27:$CN$27,1) - my formula to get the % complete
=IF(XLOOKUP("x",H28:CN28,$H$27:$CN$27,1),"","") - this returns blank cells and I can't figure out how to get the % to show up.
=AVERAGE(G28:G46) - provides overall % complete in g47
=XLOOKUP("x",H31:CN31,$H$27:$CN$27,1) - my formula to get the % complete
=IF(XLOOKUP("x",H28:CN28,$H$27:$CN$27,1),"","") - this returns blank cells and I can't figure out how to get the % to show up.
=AVERAGE(G28:G46) - provides overall % complete in g47