Calculating costs

[Daniel Louwrens]

Hi

I am using Excel 2000 SP3

I have a spread sheet of recipes where the first column is a list of
ingredients, the second column is the cost of each ingredient, immediately
adjacent to the ingredient the subsequent 31 columns are the amount of each
ingredient in each recipe.
Each recipe totals 100.
Is there some way I can calculate the cost of each recipe and have it appear
at the bottom of the recipe column.

thanks

Daniel

 

[Frank Kabel]

Hi
in C100 try:
=SUMPRODUCT($B$1:$B$99,C$1:C$99)
and copy to the right

 

[Daniel Louwrens]

Great

thanks for your help

regards

Daniel

Hi
in C100 try:
=SUMPRODUCT($B$1:$B$99,C$1:C$99)
and copy to the right