On 2002-09-06 13:39, kaldag wrote:
In column A is a discription. In column B is a value. What I want to do is sum the values in column B if the discriptions in column A match as many as two or three discriptions. I have tried a SUM array formula with no results. HELP
Ken
On 2002-09-06 14:01, kaldag wrote:
column A Column B
Mon 25
Tues 47
Wed 7412
Tues 45
Mon 58
Wed 47
Wed 45
Mon 47
Tues 45
Wed 4185
What I need is to sum all the values from column B that have Mon and Tues as disc from Column A.
Ken
On 2002-09-08 08:28, grev wrote:
I have a table with three columns, Customer#, Part # and QTY. I would like to return the Qty value associated with that part# and cust#. The problem is the customer# can be listed several times along with the same part# with differet qty's.
Example:
cust prt# qty
x 123 1
x 123 3
x 456 1
y 123 3
z 123 5
z 123 2
I was using a vlookup for cust# then another lookup for prt# but how do I add & get the sum of the same prt#? x 123 4, z 123 7
Maybe there is an easier way. Thanks for the help.
On 2002-09-08 10:42, grev wrote:
thanks for your help it worked great! Have one more question though. How can I return a value where it is in the same column as the cust#. For example:
cust #
x (has values under the same column such as)
a
g
j
How can I retrieve the value j