I am trying get totals from combined worksheet and show the results on the summary Worksheet

  • im trying to get totals from combined worksheet and show the results on the summary sheet using VBA. It needs to be VBA for the assessment meaning I cant use sum/sumIf. I have done some code but it all appears as 0 on the summary Worksheet. I'm not sure exactly what I'm getting wrong whether its the range name or some else


    the totals part of the vba code. I will also include the full code below. i am also open to a different approach if you think that may be easier/better.


    Full code. Any help is much appreciated.


  • Northern

    Changed the title of the thread from “im trying get totals from combined work sheet and show the results on the sumarry sheet” to “I am trying get totals from combined worksheet and show the results on the summary Worksheet”.
  • With numerical values, something like this should work.

    This is just an example as you should notice.