Excel formulae / VBA help

[haz_pro]

Hey all,

I am trying to figure out how to solve the following within Excel either using a fomula or VBA.

The excel is set out as follows (please note this is just a mockup for this thread):

I am trying to have the "Total Cost" for each week calculated automatically. I through I would need some sort of loop using VBA but I can't work out how to do it.

If anyone has any pointers then I would be very grateful.

Thanks.
Harry

 

[haz_pro]

Thank you for posting.

The actual spreadsheet has around 28 rows on average, with some versions containing hundreds. For this reason I was hoping that a more automated route could be taken rather than having to type out that formula over and over. Any ideas?

 

[haz_pro]

Thank for the help all.

I tried sumproduct and it is exactly what I was looking for, thanks all.