1 Reply Latest reply: May 15, 2014 9:58 AM by Bruce _ RSS

    Total Subtotals?

    Karen _

      When I subtotal in Excel I use the following formula to count the subtotals to get a count of the key values.

      =COUNTIF(A1:A351,"*Total")

      Can this be done in a Monarch summary?

        • Total Subtotals?
          Bruce _

          Karen

           

          In the summary, try the count. It should do what you do in Excel.

           

          However in Monarch it is counting the number of keys, not the number of sub-totals. In the normal scheme of things this should be the same thing.

           

            smile.gif[/img]