Nov 28 2020 05:58 PM
i am trying to create a formula that would allow me to track a project flow chart as the numbers i input.
it would have to be in a rows first lets say i need I5 through BP5 to be able to input an x into, but the formula would have to be contingent on the number of available days as listed in E5 the formula needs to give me a percentage of completion in the square H5.
so for instance the project is listed to take 5 days and i have three x's in the first three boxes(i,j,k 5) in square H5 it would have to be a percentage of 60%
can anyone help me out here
Nov 28 2020 09:42 PM
Solution@jcsizmadia That could (in H5) be something like:
=COUNTIF(I5:BP5,"x")/E5
Format cell H5 as a percentage.
Nov 29 2020 05:12 AM - edited Nov 29 2020 05:13 AM
Another variant for the @Riny_van_Eekelen model
=(XMATCH(,I5:BP5)-1)/E5
With that it doesn't matter will it be "x" or something else in cells.
Nov 29 2020 06:34 AM
Nov 28 2020 09:42 PM
Solution@jcsizmadia That could (in H5) be something like:
=COUNTIF(I5:BP5,"x")/E5
Format cell H5 as a percentage.