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?

11-10-2020, 01:15 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

Code:

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

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 08:04 AM.