If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Attachment :SUM of a colum where IF function is used
Hi,
I would like to have the sum of cloumn 'C' in the attached file. An IF function is used to derive column C. =SUM ( C1:C21) is not giving the result. Please help me. Jeevan |
#2
|
|||
|
|||
Attachment :SUM of a colum where IF function is used
I cannot see your attachment here.
Do you have any error indications in C1:C21? Such as #DIV/0 or #NA, #VALUE or others beginning with #? Those will prevent the SUM() from returning the sum. You would have to correct or eliminate such errors before the SUM() will return the correct result. IF you do have such error indications, please show us the formula being used in the cell and tell us what the error indication is. We may be able to help rewrite the formula so that your SUM() works properly. Probably a good idea to simply show us an example of the IF() statements anyhow. "Vinay Vasu" wrote: Hi, I would like to have the sum of cloumn 'C' in the attached file. An IF function is used to derive column C. =SUM ( C1:C21) is not giving the result. Please help me. Jeevan |
#3
|
|||
|
|||
Attachment :SUM of a colum where IF function is used
Take out the "1", etc so you will have NUMBERS
-- Don Guillett Microsoft MVP Excel SalesAid Software "Vinay Vasu" wrote in message ... Hi, I would like to have the sum of cloumn 'C' in the attached file. An IF function is used to derive column C. =SUM ( C1:C21) is not giving the result. Please help me. Jeevan |
#4
|
|||
|
|||
Attachment :SUM of a colum where IF function is used
"Vinay Vasu" wrote:
I would like to have the sum of cloumn 'C' in the attached file. Many people cannot see an attachment because of the news interface that they use. This includes users of Google Groups and the MS Discussion Groups web interface. Your worksheet is simple enough to describe. An IF function is used to derive column C. =SUM ( C1:C21) is not giving the result. In column C, you have formulas of the form: =IF(B2=A2,"1",IF(B2=0,"0",IF(B2A2,"-0.25"))) The root cause of your problem is: the IF expression should return numbers (1, 0, -0.25), not text ("1", "0", "-0.25"). You should write: =IF(B2=A2,1,IF(B2=0,0,IF(B2A2,-0.25))) Note: The formula can be simplified to: =IF(B2=A2,1,IF(B2=0,0,-0.25)) Also, when A2 is zero, does that give you the intended result: 1, not 0? I wonder if you really want: =IF(B2=0,0,IF(B2=A2,1,-0.25)) ----- original message ----- "Vinay Vasu" wrote in message ... Hi, I would like to have the sum of cloumn 'C' in the attached file. An IF function is used to derive column C. =SUM ( C1:C21) is not giving the result. Please help me. Jeevan |
#5
|
|||
|
|||
Attachment :SUM of a colum where IF function is used
Thanks a lot.
It worked well. Jeevan "Joe User" joeu2004 wrote in message ... "Vinay Vasu" wrote: I would like to have the sum of cloumn 'C' in the attached file. Many people cannot see an attachment because of the news interface that they use. This includes users of Google Groups and the MS Discussion Groups web interface. Your worksheet is simple enough to describe. An IF function is used to derive column C. =SUM ( C1:C21) is not giving the result. In column C, you have formulas of the form: =IF(B2=A2,"1",IF(B2=0,"0",IF(B2A2,"-0.25"))) The root cause of your problem is: the IF expression should return numbers (1, 0, -0.25), not text ("1", "0", "-0.25"). You should write: =IF(B2=A2,1,IF(B2=0,0,IF(B2A2,-0.25))) Note: The formula can be simplified to: =IF(B2=A2,1,IF(B2=0,0,-0.25)) Also, when A2 is zero, does that give you the intended result: 1, not 0? I wonder if you really want: =IF(B2=0,0,IF(B2=A2,1,-0.25)) ----- original message ----- "Vinay Vasu" wrote in message ... Hi, I would like to have the sum of cloumn 'C' in the attached file. An IF function is used to derive column C. =SUM ( C1:C21) is not giving the result. Please help me. Jeevan |
Thread Tools | |
Display Modes | |
|
|