A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Attachment :SUM of a colum where IF function is used



 
 
Thread Tools Display Modes
  #1  
Old April 17th, 2010, 02:43 PM posted to microsoft.public.excel.newusers
Vinay Vasu
external usenet poster
 
Posts: 6
Default 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  
Old April 17th, 2010, 03:58 PM posted to microsoft.public.excel.newusers
JLatham
external usenet poster
 
Posts: 1,896
Default 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  
Old April 17th, 2010, 05:07 PM posted to microsoft.public.excel.newusers
Don Guillett[_2_]
external usenet poster
 
Posts: 607
Default 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  
Old April 17th, 2010, 05:14 PM posted to microsoft.public.excel.newusers
Joe User[_2_]
external usenet poster
 
Posts: 757
Default 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  
Old April 18th, 2010, 05:43 AM posted to microsoft.public.excel.newusers
Vinay Vasu
external usenet poster
 
Posts: 6
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.