Thread
: [Solved]
How to SUM the values only if the particular cells are not empty?
View Single Post
11-10-2020, 01:15 AM
ArviLaanemets
Windows 8
Office 2016
Expert
Join Date: May 2017
Posts: 873
Code:
=if(($e$2="")+($e$5="")+($e$8="")+($e$11="")+($e$15="")>0,"",sum($e$2,$e$5,$e$8,$e$11,$e$15))
ArviLaanemets
View Public Profile
Find all posts by ArviLaanemets