#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Code:
=if(($e$2="")+($e$5="")+($e$8="")+($e$11="")+($e$15="")>0,"",sum($e$2,$e$5,$e$8,$e$11,$e$15)) |
#3
|
|||
|
|||
Thanks a lot for your kind reply. It resolved my problem.
|
#4
|
||||
|
||||
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),"") |
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 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 |