This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am attaching the file with dummy data for easy understanding.
I need to add 36 columns if you see where I can add sales 1+sales 2, receipts 1 +receipts 2, income 1 +income 2 for all the periods (which is 12 qtr). so 12 column for each sales, receipts and income 12*3=36 columns to add.
Hi @BhatiaSakshi - attached is my attempt to compute the totals across all Sales1 quarters, Sales2 quarters etc. Let us know if this suffices your request. Final total columns would look something like this:
Please mark this post as Solution Accepted if it answered your question..