Sum using probably 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
 
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
 
Back
Top