Thread: [Solved] How to SUM the values only if the particular cells are not empty?
View Single Post
 
Old 11-10-2020, 12:33 AM
Learner7 Learner7 is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default How to SUM the values only if the particular cells are not empty?
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.
Reply With Quote