How to SUM the values only if the particular cells are not empty?

[Learner7]

Hi,



How to SUM the values of column "E" only if the particular cells in column "C" are not empty?

Example:-

If the cells C2, C5, C8, C11 & C15 are not empty, then E16 should sum the values of E2, E5, E8, E11 & E15 in E16 else E16 should be blank.

How can I do that? Requesting a formula to get the job done. Thanks.

[ArviLaanemets]

=if(($e$2="")+($e$5="")+($e$8="")+($e$11="")+($e$15="")>0,"",sum($e$2,$e$5,$e$8,$e$11,$e$15))

[Learner7]

Thanks a lot for your kind reply. It resolved my problem.

[p45cal]

Originally Posted by Learner7

Thanks a lot for your kind reply. It resolved my problem.

Eh?!
That formula doesn't look at cells in column C at all!


If all 5 cells in column C need not to be empty before a sum is displayed, perhaps:
=IF(COUNTA(C2,C5,C8,C11,C15)=5,SUM(E2,E5,E8,E11,E1 5),"")