Challenge: Sum cells in one column when adjacent cells are not blank

[losamfr17]

Good morning,

My goal is to sum cells in column 2018 only when there are non blank adjacent cells in in column 2019.
Can you think of a formula to do that? Do I need to create a new formula in VBA?

Thank you in advance.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Day[/TD]
[TD]2019[/TD]
[TD]2018[/TD]
[TD]% Chg[/TD]
[/TR]
[TR]
[TD]Mon[/TD]
[TD]50[/TD]
[TD]40[/TD]
[TD]25%[/TD]
[/TR]
[TR]
[TD]Tue
[/TD]
[TD]50[/TD]
[TD]40[/TD]
[TD]25%[/TD]
[/TR]
[TR]
[TD]Wed[/TD]
[TD]50[/TD]
[TD]40[/TD]
[TD]25%[/TD]
[/TR]
[TR]
[TD]Thu[/TD]
[TD][/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fri[/TD]
[TD][/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sat[/TD]
[TD][/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sun[/TD]
[TD][/TD]
[TD]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cum Total Week 1[/TD]
[TD]150[/TD]
[TD]120[/TD]
[TD]25%[/TD]
[/TR]
</tbody>[/TABLE]

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Day[/TD]
[TD]

2019​

[/TD]
[TD]

2018​

[/TD]
[TD]% Chg[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]Mon[/TD]
[TD]

50​

[/TD]
[TD]

40​

[/TD]
[TD]

0.25​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]Tue[/TD]
[TD]

50​

[/TD]
[TD]

40​

[/TD]
[TD]

0.25​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]Wed[/TD]
[TD]

50​

[/TD]
[TD]

40​

[/TD]
[TD]

0.25​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]Thu[/TD]
[TD][/TD]
[TD]

40​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]Fri[/TD]
[TD][/TD]
[TD]

40​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]Sat[/TD]
[TD][/TD]
[TD]

40​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD]Sun[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]Cum Total Week 1[/TD]
[TD]

150​

[/TD]
[TD]

120​

[/TD]
[TD]

0.25​

[/TD]
[/TR]
</tbody>[/TABLE]

B9=SUMIFS(B2:B8,C2:C8,"<>")

 

[wrightyrx7]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Day[/TD]
[TD]

2019​

[/TD]
[TD]

2018​

[/TD]
[TD]% Chg[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]Mon[/TD]
[TD]

50​

[/TD]
[TD]

40​

[/TD]
[TD]

0.25​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]Tue[/TD]
[TD]

50​

[/TD]
[TD]

40​

[/TD]
[TD]

0.25​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]Wed[/TD]
[TD]

50​

[/TD]
[TD]

40​

[/TD]
[TD]

0.25​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]Thu[/TD]
[TD][/TD]
[TD]

40​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]Fri[/TD]
[TD][/TD]
[TD]

40​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]Sat[/TD]
[TD][/TD]
[TD]

40​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD]Sun[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]Cum Total Week 1[/TD]
[TD]

150​

[/TD]
[TD]

120​

[/TD]
[TD]

0.25​

[/TD]
[/TR]
</tbody>[/TABLE]

B9=SUMIFS(B2:B8,C2:C8,"<>")

Then just switch the ranges for columns C
C9=SUMIFS(C2:C8,B2:B8,"<>")

 

[losamfr17]

Thank you very much!