Sum using a Vlookup

  • Thread starter Thread starter Alex Langlois
  • Start date Start date
A

Alex Langlois

Hi,
I'm looking for a way to make a sum of values in a column depending on
the respective value of another column.

Example:

A1 = 1
A2 = 2
A3 = 1

B1 = 100
B2 = 300
B3 = 125

I'd like to be able to make a sum of B values when A values = 1. In that
case, my sum would be 225.

Thanks,

Alex
 
You can use SumIf.

=SUMIF(A1:A3,1,B1:B3)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi,
I'm looking for a way to make a sum of values in a column depending on
the respective value of another column.

Example:

A1 = 1
A2 = 2
A3 = 1

B1 = 100
B2 = 300
B3 = 125

I'd like to be able to make a sum of B values when A values = 1. In that
case, my sum would be 225.

Thanks,

Alex
 
I'll be darned, I didn't even remember that!
You must be younger then me John.<g>
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Why don't you use way the three responders to your exact same question
on August 21st gave you?

Instead of reposting a question, please look through the previous
threads. If you can't find your post in your newsreader, you can always
find it in the archives:

http://groups.google.com/advanced_group_search?q=group:*excel*

Use your name in the Author box.
 
I didn't think I looked that young ... at least not in MY mirror!<g>


I goofed. Picture is of you, JE.<G>
BTW. Don't most of us use oe?
 
Back
Top