IF Function/Validation List/Totals
 

Hi,

Using the rather ageing X L97 I'm trying to do the following:

Column G uses a Data Validation List to restrict choices,
Column H the uses an IF function to place a value into the cell,

I now need to setup a display of results that then count the values of the
results in Column H as a total of so if H18,H20,H35 have the value 4 then my
count would be 3, if H19,H21,H30,H33 have the value 5 then the count would be
4.
The actual column i'm using is going to be around 500 rows down and the data
needs to be taken accordingly.
Any suggestions?

If it helps the IF function i'm using in Column H is as follows:

=IF(G15='Result 1',"1",IF(G15='Result 2',"2",IF(G15='Result
3',"3",IF(G15='Result 4',"4",IF(G15='Result 5',"5",IF(G15='Result
6',"6",IF(G15='Result 7',"7",IF(G15='Result 8',"8"))))))))

The validation list I'm using could also get larger I believe using the IF
function to check and then disaply the results could get messy, are there any
other ways to display the results in Column H rather than using the IF
function?

Thanks in advance,

IF Function/Validation List/Totals
 

Count all 4's in H1:H500
=COUNTIF(H1:H500,"4")

Formula in column H
=IF(G15<"",--MID(G15,8,3),"")


"Phendrena" skrev:

Hi,

Using the rather ageing X L97 I'm trying to do the following:

Column G uses a Data Validation List to restrict choices,
Column H the uses an IF function to place a value into the cell,

I now need to setup a display of results that then count the values of the
results in Column H as a total of so if H18,H20,H35 have the value 4 then my
count would be 3, if H19,H21,H30,H33 have the value 5 then the count would be
4.
The actual column i'm using is going to be around 500 rows down and the data
needs to be taken accordingly.
Any suggestions?

If it helps the IF function i'm using in Column H is as follows:

=IF(G15='Result 1',"1",IF(G15='Result 2',"2",IF(G15='Result
3',"3",IF(G15='Result 4',"4",IF(G15='Result 5',"5",IF(G15='Result
6',"6",IF(G15='Result 7',"7",IF(G15='Result 8',"8"))))))))

The validation list I'm using could also get larger I believe using the IF
function to check and then disaply the results could get messy, are there any
other ways to display the results in Column H rather than using the IF
function?

Thanks in advance,