Finding the sum of several variables over several weeks automatically

Hi all,

Here is my problem:

Column A contains a week number, for example '23' let's call it 'Week'.

Column B contains one of the 3 types of product that is manufactured, let's call it 'Product'.

Column C contains quantities of each types of manufactured product, let's call it 'Quantity'.

Column D i have created as a 'Weekly cutoff point' which displays a '1' when weeks change, i.e. 23 to 24.

There are then 3 other columns, 1 for each different type of product. The formula in these columns will look up 'Product' and if it matches that particular type then it will display 'Quantity' from column B.

What I am aiming to achieve is a sum of the quantities of each product manufactured for each week. This however is made difficult by the fact that the number of orders for each week varies, therefore the number of rows in each week is different - and i cannot see how i would use a formula to automatically calculate totals for each week.

Is this possible using a normal formula, or would some VB code be required? I am unfamiliar with VB also, could anyone steer me in the right direction?

Thanks

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!