Formula to exclude first two values

[BiggusDoggus]

Hi all

So I have a table of data (example below - consider the table as starting in A1):

	Jan	Feb	Mar	Apr	May	Jun
Z Ltd	36	24	3	4	6	5
Y Ltd			32	31	2	3
Z Ltd		43	35	4	3	1
A Ltd	9	10	1	1	2	1

<tbody>
</tbody>

What I would like please is a formula that takes either the sum or average (doesn't matter which) for each row, but excluding the first 2 values. In essence, the first 2 numbers are during a trial period, so only want to look at the numbers after the first two months for each company.

I could do this manually, except my actual table is quite large, and is updated regularly.

Is it possible please?

 

[BiggusDoggus]

Thanks for all the help guys - went with

=SUM(IF(COLUMN(B2:G2)<=SMALL(IF(ISNUMBER(B2:G2),COLUMN(B2:G2)),2),B2:G2))

Works great.

Hi again. Sorry, slight modification. I need to get up to the first 2 numbers please. So if there is only 1, include that one. And if there's 2, sum the 2. The above formula errors out if there's less than 2 values.

Thanks!

 

[Aladin Akyurek]

Hi again. Sorry, slight modification. I need to get up to the first 2 numbers please. So if there is only 1, include that one. And if there's 2, sum the 2. The above formula errors out if there's less than 2 values.

Thanks!

Control+shift+enter, not just enter:

=SUM(IF(COLUMN(B2:G2)<=SMALL(IF(ISNUMBER(B2:G2),COLUMN(B2:G2)),MIN(2,COUNT(B2:G2))),B2:G2))

Even...

=IFERROR(SUM(IF(COLUMN(B2:G2)<=SMALL(IF(ISNUMBER(B2:G2),COLUMN(B2:G2)),MIN(2,COUNT(B2:G2))),B2:G2)),"no data")

 

[BiggusDoggus]

Control+shift+enter, not just enter:

=SUM(IF(COLUMN(B2:G2)<=SMALL(IF(ISNUMBER(B2:G2),COLUMN(B2:G2)),MIN(2,COUNT(B2:G2))),B2:G2))

Even...

=IFERROR(SUM(IF(COLUMN(B2:G2)<=SMALL(IF(ISNUMBER(B2:G2),COLUMN(B2:G2)),MIN(2,COUNT(B2:G2))),B2:G2)),"no data")

Perfect, thank you!!

 

[Aladin Akyurek]

Perfect, thank you!!

Glad to help.