Main Totals and Subtotals for grouped items

**trosasco** · 06-05-2013, 10:49 AM

Hello, I'm working on a report that needs to add the main count of all subtotals in my grouped report. The way I do this now is manual. I click on D1499, start with the = sign and highlight each subtotal above one by one so my formula ends up looking as you see it below.

=D1497+D1495+D1493+D1489+D1483+D1473+D1447+D1429+D1461+D1407+D1382+D1357+D1332+D1304+D1276+D1247+D1216+D1185+D1153+D1121+D1089+D1057+D1024+D990+D956+D922+D888+D854+D818+D782+D746+D710+D674+D638+D602+D566+D530+D494+D458+D422+D386+D348+D308+D269+D231+D194+D157+D119+D81+D50+D18

Is there another formula that will count all the subtotals at once?

Sometimes this report is bigger that this so its very time consuming. Please help.Payment Report 6.5.2013.xlsx

**Pete_UK** · 06-05-2013, 11:03 AM

How about something like this in D1499:

=SUMIF(L2:L1497,"*total",D2:D1497)

i.e. add from those cells in column D where column L cells contain the word Total.

Hope this helps.

Pete

**trosasco** · 06-05-2013, 11:12 AM

Thank you so much.. That cleared up one part of my report. You're awesome.

**arlu1201** · 06-05-2013, 11:39 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.