Results 1 to 5 of 5

Main Totals and Subtotals for grouped items

Threaded View

trosasco Main Totals and Subtotals for... 06-05-2013, 10:49 AM
Pete_UK Re: Main Totals and Subtotals... 06-05-2013, 11:03 AM
trosasco Re: Main Totals and Subtotals... 06-05-2013, 11:12 AM
arlu1201 Re: Main Totals and Subtotals... 06-05-2013, 11:39 AM
trosasco Re: Main Totals and Subtotals... 06-05-2013, 12:12 PM
  1. #1
    Registered User
    Join Date
    04-23-2012
    Location
    Davie, FL
    MS-Off Ver
    Excel 2013
    Posts
    83

    Main Totals and Subtotals for grouped items

    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
    Last edited by trosasco; 06-05-2013 at 03:10 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1