I am trying to program a chat which has multiply y data and included in that is the subtotal range

I know how to reference the datarange and use intersect but I can't get to the subtotal ranges so I am assuming I am missing something obvious in the syntax i.e. subtotalrnage or something

I have one set of row data "month"
I have columns for entry year, product and the "data" column (with the sigma sign)
I have two fields from the same data source, one set as xlsum (this is the "monthly total") and one set as xlrunningtotal (this is the "Cumulative total")
The code below just selects the "cumulative data" columns for each product, not the "2013 cumulative data" column which is the running total of all the products over each month


Please Login or Register  to view this content.