if yes in this column then add that column?

  • Thread starter Thread starter matt
  • Start date Start date
M

matt

I'm looking for a little assistance with creating an
equation.
Column A is dollar figures
Column B is alpha character codes

If a cell from column B matches a specific alpha code
then get the dollar figure from A. Move to the next cell
down and if the alpha code matches ADD the dollar
amount. Repeat.

Anybody got any ideas? To make it more complicated I
want it to go to another sheet. I presume I'll be able
to define that in the range once I have a function.

Thank you very much.
 
Frank, you've been a big help to me in the past. Thanks
once again. Your help has been invaluable.

Matt
 
I would use match....

In c1
=indirect(("a"&(MATCH("Alphacodehere",b:b,0))))
In c2
=indirect(("a"&(MATCH("Alphacodehere",b:b,0)+1)))
In c3
=MATCH("Alphacodehere",b:b,0)
In c4
=if(("b"&MATCH("Alphacodehere",b:b,0)=("b"&(MATCH("Alphacodehere",b:b,0)+1),C1+C2,""
 
Back
Top