Last 3 month Income

[Lasantha]

Dear Team,

Could you please help me to get last 3 month income to Column C. Please see the attached example,

Jan=Jan
Feb=Jan+Feb
Mar=Jan+Feb+Mar


Sep=Jul+Aug+Sep

Thank you.
Lasantha.

 

[vletm]

Lasantha
to C2
=SUMIFS(B$2:B$25,A$2:A$25,">"&EOMONTH(A2;-3),A$2:A$25,"<="&A2)
and copy down

 

[Lasantha]

Lasantha
to C2
=SUMIFS(B$2:B$25,A$2:A$25,">"&EOMONTH(A2;-3),A$2:A$25,"<="&A2)
and copy down

Thank you

 

[bosco_yip]

In C2, copied down :

=SUM(OFFSET(B2,,,-MIN(3,ROW(B2))))

Regards
Bosco

 

[Lasantha]

In C2, copied down :

=SUM(OFFSET(B2,,,-MIN(3,ROW(B2))))

Regards
Bosco

Thank you

 

[Mamdouh Elfors]

Dears
I only want the third digit in column B
Thanks

 

[Mamdouh Elfors]

I am sorry I want to correct the required
I want every third number in column B
Thanks

 

[bosco_yip]

I am sorry I want to correct the required
I want every third number in column B
Thanks

Return every third number in column B

Please refer to post #.1 file, in D2, copied down :

=IFERROR(INDEX(B$2:B$25,AGGREGATE(15,6,ROW(B$2:B$25)-ROW(B$1)/(B$2:B$25>0)/(MOD(ROW(B$2:B$25),3)=1),ROWS($1:1))),"")

Regards
Bosco

 

[Mamdouh Elfors]

Return every third number in column B

Refer to post #.1 file, in D2, copied down :

=IFERROR(INDEX(B$2:B$25,AGGREGATE(15,6,ROW(B$2:B$25)-ROW(B$1)/(B$2:B$25>0)/(MOD(ROW(B$2:B$25),3)=1),ROWS($1:1))),"")

Regards
Bosco

Thank you