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))

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 11:50 AM.