View Single Post
  #4   Report Post  
Old April 17th 10, 05:14 PM posted to microsoft.public.excel.newusers
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 905
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(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