Solve : Excel problem 1 - adding TRUE's?

1.	Solve : Excel problem 1 - adding TRUE's?
Answer» I have SET up various times tables (ie 1X2 = , 2X2= etc) that I WANT students to enter in the correct value where a cell in that row will SHOW TRUE or FALSE. I now wish to automaticaly add up all the TRUE answers, Can anybody advsie how I can do this. I am using Exel 2002. ThanksYou could do it several WAYS. One is to use the "if" function. Place a formula similar to this is a cell and then copy it down to all the others. Sum the results in other column and hide and protect this column. =IF(E3 = TRUE,1,0)Thanks Gussery, you have been a great help for both problems, the adding is comming along nicely. Gerry

Discussion