Not being able to add the values of my cell

saritan · May 17th, 2002, 12:16 AM

I have several columns that contain data.
If column A and Column B contain data. Then I have the following formula to put the answer in a third column. =IF(A1=B1,"1","0")

Then I want to add the cells to give me a total.

Here in lies the problem. The Sum function does not work. it will not add the cells and display the total. i can do the following and that is add each cell individually but with 1500 lines and 20 columns it will take some time. Is there an other way to do this?

anno · May 17th, 2002, 12:34 AM

when you say the sum function doesn't work, what result is it returning?

edit
ah. see it now. leave the ""s out. if you want to leave them in, use =COUNTA(C1:C1500) instead

[ This Message was edited by: anno on 2002-05-16 23:36 ]

[ This Message was edited by: anno on 2002-05-16 23:37 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 17th, 2002, 12:16 AM	#1
saritan New Member Join Date: May 2002 Posts: 1	I have several columns that contain data. If column A and Column B contain data. Then I have the following formula to put the answer in a third column. =IF(A1=B1,"1","0") Then I want to add the cells to give me a total. Here in lies the problem. The Sum function does not work. it will not add the cells and display the total. i can do the following and that is add each cell individually but with 1500 lines and 20 columns it will take some time. Is there an other way to do this?

May 17th, 2002, 12:34 AM	#2
anno Board Regular Join Date: Feb 2002 Posts: 202	when you say the sum function doesn't work, what result is it returning? edit ah. see it now. leave the ""s out. if you want to leave them in, use =COUNTA(C1:C1500) instead [ This Message was edited by: anno on 2002-05-16 23:36 ] [ This Message was edited by: anno on 2002-05-16 23:37 ]