Sum using a Vlookup

[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

 

[RagDyer]

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

 

[JE McGimpsey]

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.

 

[RagDyer]

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.

 

[JE McGimpsey]

You must be younger than me

Yup - that's me, ol' babyface:

http://www.microsoft.com/communities/mvp/mvpdetails.mspx?Params=~CMTYDa
taSvcParams%5e%7earg+Name%3d%22guid%22+Value%3d%22a81be233-4910-4acd-b367
-c4d0444726df%22%2f%5e%7esParams%5e%7e%2fsParams%5e%7e%2fCMTYDataSvcParam
s%5e

 

[Don Guillett]

For those that don't want to cut/paste 4 lines to get to see Rag's baby
face.

http://tinyurl.com/5pu53

 

[JE McGimpsey]

Or simply get a newsreader that knows how to deal with multi-line
URLs... <g>

 

[Don Guillett]

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

 

[JE McGimpsey]

BTW. Don't most of us use oe?

16.6% by posting. See

http://www.tushar-mehta.com/excel/ngstats/overview-newsreaders.html

 

[RagDyeR]

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?