Prev: sum function
Next: UTF-8 Delimited
From: klawk on 18 Apr 2010 10:52
I have the following spreadsheet.
1609719837 M51410 10 Ser - 5/8" x 50 Ft. 2000
1609710593 2058100 5/8 X 100 Platinum 100
1609718669 10TNSGF 10 Ser - 1/2" x 50 Ft
1609719839 M51470 25 Ser - Industrial 3/4" x 75 Ft. 500

Column A is Product Number, Column B is a Description and Column C is the
number of pieces we will be producing.
I have a table that does a vlookup on the Product Number and returns a unit
of measure which I multiple by the number of pieces we will be producing. My
question is how can I have one formula at the bottom of column C that will do
all the vlookups and then sum them together.
From: Teethless mama on 18 Apr 2010 11:20
Take a look SUMIF function in help menu


"klawk" wrote:

> I have the following spreadsheet.
> 1609719837 M51410 10 Ser - 5/8" x 50 Ft. 2000
> 1609710593 2058100 5/8 X 100 Platinum 100
> 1609718669 10TNSGF 10 Ser - 1/2" x 50 Ft
> 1609719839 M51470 25 Ser - Industrial 3/4" x 75 Ft. 500
>
> Column A is Product Number, Column B is a Description and Column C is the
> number of pieces we will be producing.
> I have a table that does a vlookup on the Product Number and returns a unit
> of measure which I multiple by the number of pieces we will be producing. My
> question is how can I have one formula at the bottom of column C that will do
> all the vlookups and then sum them together.
 | 
Pages: 1
Prev: sum function
Next: UTF-8 Delimited