Problem summing several variables quantities over inconsistent week lengths

[tunabeast]

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

 

[aniketbhanu]

You can use the "Sumif" function.
Lets say you have three products A, B and C.

sum of quantity of product A would be given by

=sumif(B:B,"=A",C:C)

Hope that helps.