Vlookup ??

  • Thread starter Thread starter Steve Mc
  • Start date Start date
S

Steve Mc

I need to have all of John's hours in the B column total,
and also all of Bills.
I think it'd be a vlookup, but I always have truoble with
that function.
....if it finds John in the A column, then sum all of
those 'John' numbers in the B column, and total it... etc.

Thanks,

A B
John total->
Bill total->

John 6.99
Bill 8
John 8
John 8
John 7
John 8
John 7
Bill 8.02
Bill 8
Bill 8.01
Bill 8.02
Bill 10
Bill 7.55
John 8
Bill 8
Bill 8.43
 
Hi Steve

in this case i would use the SUMIF function

=SUMIF(A1:A100,"John",B1:B100)

likewise for Bill

VLOOKUP is used to lookup A value in the first column of a table and return
a value from another column in the same row as the lookup value.

Hope this helps
Cheers
JulieD
 
Thanks guys,

That wroked great. So simple...
-----Original Message-----
Hi
try
=SUMIF(A1:A1000,"John",B1:B1000)
and
=SUMIF(A1:A1000,"Bill",B1:B1000)

--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
Back
Top