Hi need some excel help, does anyone know of a formula in Excel to count cells in a range if they do not equal a ?U? and then double the count in a cell one of the columns cells in that range.
For example cells row one column A:C have 3 grades All are 9-1 grades so would need that to equal 4 in Cell D
However if row 2 contains a U in A:B but a 9-1 in column C it would enter 2 as the count in Column D.
I?ve got the count only formula if not a u but can?t quite work out how to add a formula to double the count in in column C if it?s not a U
=if(countif(RANGE,?<>U?)=0,0, (countif(RANGE,?<>U?)+1))
The above still counts a U so i get 3 in cell D4 instead of 2
Hope that makes sense? I've attached an example to help understand
Bookmarks