Thread: [Solved] How to SUM the values only if the particular cells are not empty?
View Single Post
 
Old 11-10-2020, 01:15 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Code:
=if(($e$2="")+($e$5="")+($e$8="")+($e$11="")+($e$15="")>0,"",sum($e$2,$e$5,$e$8,$e$11,$e$15))
Reply With Quote