Page 1 of 1

sub total

Posted: Mon Nov 09, 2020 8:51 am
by sna
Hi dear,
I need your help to sum value upon last number in a column for example
1
2
3
4 sum
1
2
3
4
5
6
7
8 sum
1
2
3 sum
1
2
3
4
5 sum

Thanks

Re: sub total

Posted: Mon Nov 09, 2020 9:30 am
by logic
It should be this formula.

F2 =IF(A3<A2,SUM(C$2:C2)-SUM(F$1:F1),"") Enter and copy down.

Re: sub total

Posted: Mon Nov 09, 2020 11:04 am
by sna
Thank it works