formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need help in creating a formula that would just look at the first column A
and then give me the values in the other columns that i indicate example from
column B and C. In brackets is an example what is in the columns just so you
have an idea. So the problem is since in column A has the same p.o. repeating
for a couple of rows and i want all those rows info from B and C. basically
what i am trying to do is make a invoice and i want to use this sheet below
for it to capture the data by p.o. number. hope i make sense. any help
would be great. thanks
column A column B column C
(eg. p.o.) (eg. qty) (eg. cost)
12234 120 1.00
12234 360 2.00
12234 400 3.20
12234 500 1.00
45454 140 4.00
45454 60 5.00
 
Hi

Assuming you place the required PO numbers in D2, D3 etc. then in E2 enter
=SUMIF($A:$A,$D2,B:B)
copy across to F2 and copy both formulae down as far as required

Alternatively, you can use SUMPRODUCT() but note that you cannot use whole
columns arguments, you would have to define a range which is less than the
whole column.

=SUMPRODUCT(($A$2:$A$100=$D2)*B$2:B$100)
copy across to F2 and copy both formulae down as far as required
 
Back
Top