Thread: Attachment :SUM of a colum where IF function is used
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
  
Posts: 1,522
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




Reply With QuoteReply With Quote