Notifications
Clear all
Topic starter
Hi There,
On a weekly report I need to get the totals of specific rows from a worksheet I copy in every week, however the number of columns change each week,
I have attached an example, I want the total of the highlighted row to appear on a new worksheet, but by using a Vlookup or Sumif formular based on the row name.
Any help gratefully accepted
Thanks
Paul
Posted : 08/02/2018 2:22 pm
Hi Paul
See if this is what you want.
I am assuming you wanted a single total for an entire row irrespective of the number of columns.
Hope this helps
Sunny
Posted : 08/02/2018 7:23 pm
Please try this one.
Posted : 08/02/2018 8:48 pm
Topic starter
Thank you Sunny & Clark for giving me the answer with different solutions, great, gives me options plus have learned a lot
Regards
Paul
Posted : 09/02/2018 5:03 am
Hi Paul
Thanks for your feedback.
Glad we were able to help.
Sunny
Posted : 09/02/2018 9:20 pm
