Sum a column in groups
 

Hey I was wondering if there was a way to have a column summed up in a certain total. Like i have a 100 numbers in a column I can get the column split summed into 5 different groups of 20. I would also it need it to skip blank cells. and sum the first 20 values as they appeared in the column.

Thanks in advance

Sum a column in groups
 

Hi,

Am Thu, 6 Jul 2017 22:40:19 +0100 schrieb Mjc39:

Hey I was wondering if there was a way to have a column summed up in a
certain total. Like i have a 100 numbers in a column I can get the
column split summed into 5 different groups of 20. I would also it need
it to skip blank cells. and sum the first 20 values as they appeared in
the column.

for the first 20 numbers ignoring blanks try:
=SUM(INDIRECT("A1:A"&SMALL(IF(A1:A100<"",ROW(1:10 0)),20)))
and enter the formula with CTRL+Shift+Enter


Regards
Claus B.
--
Windows10
Office 2016