MeraWindows Forums - Get your Computer Problems Fixed

This is a site run by the community - for the community. At the site, we share and contribute our computer learnings with each other. We discuss about Windows, Office, Mobile, Gaming and other computer related topics. At our forums you can post your queries and our very helpful community members will respond quickly to your queries. We organize lots of competitions from time to time and award prizes to the winners.
You will need to register at the site before posting in forums. It's absolutely free. After registering, you can get all the benefits available to our registered members, you can access our Downloads section, you can participate in contests, etc. You can post in forums in English as well as in Hindi, in fact we encourage you to use Hindi in your posts. If you have any problem with registration or login, please contact us.

Search Home All Forums

Home

Microsoft Offic...

Microsoft Excel

Multiple Rows and Columns aggregate, condition based

7/27/2011 10:06 PM

Awanish

Joined: 7/27/2011

Posts: 2

Multiple Rows and Columns aggregate, condition based Modified By Awanish on 8/2/2011 10:22:52 AM

Hi Ashish!

Please find attached an ordersheet sheet with campaign collaterals. There are multiple stores, and each store is having multiple number of windows, as well as other collaterals, which are again having variable conditions.

while keeping all the elements in a single row ( multiplying them by respective numbers) and adding formulae for them manually, I am able to achieve the required total costing.

But I want to make it more generic, so that any one could get the total store costing, just by putting the 1st window and their collaterals in one row, 2nd window and their collaterals in 2nd row, and 3rd windows collateral in 3rd row, and respectively.

No. of window, and all other dependants vary from store to store.

Is it possible to come up with a solution so that any one can get the total costing for a particular store just by putting different windows details in different rows, yet managing to get the total final costing?

Looking forward to your kind help.

Thanks and kind regards,

Awanish