cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

summing alternate column or row

S KRISHNASWAMY
Copper Contributor

‎Nov 16 2020 07:38 PM

‎Nov 16 2020 07:38 PM

summing alternate column or row

I want add only alternate columns and get sum total.

Labels:
828 Views
0 Likes
1 Reply
Reply
1 Reply
Sergei Baklan

‎Nov 17 2020 12:28 AM

‎Nov 17 2020 12:28 AM

Re: summing alternate column or row

@S KRISHNASWAMY 

That could be something like

=SUMPRODUCT( range*(MOD(COLUMN(range),2)=1))
0 Likes
Reply