N
Newfie809
A B C D E F
ENG4C1 ENG3U1 ENG3U1 0 0 0
=ROUND((COUNTIF(B3,"<>")+COUNTIF(C3,"<>")+COUNTIF(G3,"<>")+MIN(COUNTIF(D3:F3,"<>"),1))/3,2 )
This formula adds the columns B=.333, C=.333, D E F=.333 & G=.333 for a
total of 1.33 and I would like it to be 1.0
I am trying to add the columns that have a code in them and the ones that
have a 0 should not be added. Each cell has a lookup formula that returns
the information from another workbook and if there is no information for the
formula in the other workbook it returns a zero and therefore if there is
something in the cell it get added to the total and I do not want it added to
the total.
What I am looking for is the formula to only count the cells that have a
code in them. If there is a 0 there I do not want the cell to add to the
formula.
Is this possible? I tried a COUNTA but that did not work.
Thank you
ENG4C1 ENG3U1 ENG3U1 0 0 0
=ROUND((COUNTIF(B3,"<>")+COUNTIF(C3,"<>")+COUNTIF(G3,"<>")+MIN(COUNTIF(D3:F3,"<>"),1))/3,2 )
This formula adds the columns B=.333, C=.333, D E F=.333 & G=.333 for a
total of 1.33 and I would like it to be 1.0
I am trying to add the columns that have a code in them and the ones that
have a 0 should not be added. Each cell has a lookup formula that returns
the information from another workbook and if there is no information for the
formula in the other workbook it returns a zero and therefore if there is
something in the cell it get added to the total and I do not want it added to
the total.
What I am looking for is the formula to only count the cells that have a
code in them. If there is a 0 there I do not want the cell to add to the
formula.
Is this possible? I tried a COUNTA but that did not work.
Thank you