Thread: Attachment :SUM of a colum where IF function is used
View Single Post
  #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