Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTING GROUPS IN ONE COLUMN | Excel Discussion (Misc queries) | |||
Breakout groups from one column of data | Excel Discussion (Misc queries) | |||
Ranking different groups in one column | Excel Discussion (Misc queries) | |||
Analysing different groups of data in the same column | Excel Discussion (Misc queries) | |||
summing groups in a column | Excel Programming |