Sum using probably a VLOOKUP

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
 
R

RagDyeR

Try this:

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum using a Vlookup 9
dynamic vlookup then sum 3
Very strange behaviour of VLOOKUP in Excel 2010 4
sum vlookup results 5
Search for a sum! 4
Trouble flagging conditions in Excel using VB 6
Excel Complex Summing 3
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3

Top