Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2020, 12:33 AM
Learner7 Learner7 is offline How to SUM the values only if the particular cells are not empty? Windows XP How to SUM the values only if the particular cells are not empty? Office 2007
Advanced Beginner
How to SUM the values only if the particular cells are not empty?
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 11-10-2020, 01:15 AM
ArviLaanemets ArviLaanemets is offline How to SUM the values only if the particular cells are not empty? Windows 8 How to SUM the values only if the particular cells are not empty? Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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
  #3  
Old 11-10-2020, 02:00 AM
Learner7 Learner7 is offline How to SUM the values only if the particular cells are not empty? Windows XP How to SUM the values only if the particular cells are not empty? Office 2007
Advanced Beginner
How to SUM the values only if the particular cells are not empty?
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default

Thanks a lot for your kind reply. It resolved my problem.
Reply With Quote
  #4  
Old 11-10-2020, 02:47 AM
p45cal's Avatar
p45cal p45cal is offline How to SUM the values only if the particular cells are not empty? Windows 10 How to SUM the values only if the particular cells are not empty? Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by Learner7 View Post
Thanks a lot for your kind reply. It resolved my problem.
Eh?!
That formula doesn't look at cells in column C at all!


If all 5 cells in column C need not to be empty before a sum is displayed, perhaps:
=IF(COUNTA(C2,C5,C8,C11,C15)=5,SUM(E2,E5,E8,E11,E1 5),"")
Reply With Quote
Reply

Thread Tools
Display Modes


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 SUM the values only if the particular cells are not empty? 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 09:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft