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