SOLVED

spreadsheet formula

Copper Contributor

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

3 Replies
best response confirmed by jcsizmadia (Copper Contributor)
Solution

@jcsizmadia That could (in H5) be something like:

=COUNTIF(I5:BP5,"x")/E5

Format cell H5 as a percentage.

Screenshot 2020-11-29 at 06.42.06.png

@jcsizmadia 

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.

 

thanks for the response and the pic it surely helped me out
1 best response

Accepted Solutions
best response confirmed by jcsizmadia (Copper Contributor)
Solution

@jcsizmadia That could (in H5) be something like:

=COUNTIF(I5:BP5,"x")/E5

Format cell H5 as a percentage.

Screenshot 2020-11-29 at 06.42.06.png

View solution in original post