Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
"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(B2<A2,"-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(B2<A2,-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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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(B2<A2,"-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(B2<A2,-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 |
#6
![]() |
|||
|
|||
![]()
Hello! I think it would be so much easier to use the SUMIF Function in excel for a conditional sum of values.
The way to use SUMIF is: =SUMIF(range, criteria, sum_range) range - range of where you will check the critiera criteria - the condition where you will check whether to add the value sum range - the range to be summed based on the condition So it will easily add all values based on the condition you set. Hope this helps! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUM of a colum where IF function is used | New Users to Excel | |||
Different colum widths for same colum in different areas of worksh | Excel Worksheet Functions | |||
colum 1 = product #'s than colum 2 = prod. disc. | Excel Discussion (Misc queries) | |||
Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
Check data on colum A and find match on colum b | Excel Discussion (Misc queries) |