View Single Post
  #2   Report Post  
Old April 17th 10, 03:58 PM posted to microsoft.public.excel.newusers
JLatham JLatham is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,203
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

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

"Vinay Vasu" wrote:


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.