Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.newusers




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
Posted to microsoft.public.excel.newusers




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
Posted to microsoft.public.excel.newusers




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
Posted to microsoft.public.excel.newusers




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(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




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(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




Sumif
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  


Similar Threads  
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) 