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

		Microsoft Office Forums > Microsoft Excel > Excel
How to SUM the values only if the particular cells are not empty?

FAQ

Thread Tools

Display Modes

11-10-2020, 12:33 AM

Learner7

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

Office 2007

Advanced Beginner

Join Date: May 2010

Posts: 51

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
auto progress number evenly between two values across empty cells ?	DBenz	Excel	4	03-28-2018 04:46 AM
If a2 is not empty, color empty cells in b2:af2	turkanet	Excel	2	08-20-2017 11:00 PM
How to get rid of empty cells.	nicholes	Excel	7	12-23-2013 06:27 PM
How do you loop through an array with some empty values?	omahadivision	Excel Programming	5	11-28-2013 10:49 AM
Apparently empty (blank) cells aren't empty	daymaker	Excel	3	03-08-2012 03:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:11 AM.