YasserKhalil
Well-Known Member
Hello everyone
I have values in column A and there are blanks within these cells
I need to get the totals for two non-empty cells beside the current cell and the result would be put in adjacent column
For example the first value is in A1 and the second value is in A4 and the third value is in A6
Here in B6 I need to sum the A1 & A4 & A6
Then in A11 there is the value 11 so in B11 , I need to sum A4 & A6 & A11
Ans so on
Here's a sample of the desired results
Thanks advanced for help
I have values in column A and there are blanks within these cells
I need to get the totals for two non-empty cells beside the current cell and the result would be put in adjacent column
For example the first value is in A1 and the second value is in A4 and the third value is in A6
Here in B6 I need to sum the A1 & A4 & A6
Then in A11 there is the value 11 so in B11 , I need to sum A4 & A6 & A11
Ans so on
Here's a sample of the desired results
Thanks advanced for help