Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi All
I have two columns (Data 1 and Data 2) that need to be consolidated (Result Column) Example: Data 1 Data 2 Result 1 6 7 2 7 9 5 9 14 6 10 16 9 19 28 I consolidated the data columns using the following formula: =IF(AND(ISBLANK(B3),ISBLANK(C3)),"",B3+C3) When a graph is created for the result column the graph return to zero at each "empty" cell. Could anyone please help to solve the problem. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Ignoring empty cells | Excel Discussion (Misc queries) | |||
In Bar Chart, can we display both figures and their respective %a. | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
empty cells in ranges | Excel Discussion (Misc queries) |