Remember Me?

#1
February 18th 05, 09:49 PM
 Telly Posts: n/a
SUMIF using VLOOKUP as criteria

Is the SUMIF function able to use a VLOOKUP as a criteria? I am trying to add
numbers having the same account number, where the account number and numbers
to be added are in another workbook. Do I put the VLOOKUP criteria in quotes?
Here's what I have:

=SUMIF(range in the other workbook showing account numbers, VLOOKUP(cell in
current workbook, range in other workbook,column in other workbook, false),
sumrange in other workbook)

Is there another way to do this? Thanks.

#2
February 18th 05, 11:17 PM
 Jason Morin Posts: n/a

Yes, you can use VLOOKUP to return a value to use as the
criteria portion of SUMIF. Here's an example:

=SUMIF([Book6]Sheet1!\$A:\$A,VLOOKUP(A1,[Book6]Sheet1!
\$G:\$H,2,0),[Book6]Sheet1!\$B:\$B)

HTH
Jason
Atlanta, GA

-----Original Message-----
Is the SUMIF function able to use a VLOOKUP as a

criteria? I am trying to add
numbers having the same account number, where the

account number and numbers
to be added are in another workbook. Do I put the

VLOOKUP criteria in quotes?
Here's what I have:

=SUMIF(range in the other workbook showing account

numbers, VLOOKUP(cell in
current workbook, range in other workbook,column in

other workbook, false),
sumrange in other workbook)

Is there another way to do this? Thanks.
.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post mark Excel Discussion (Misc queries) 1 January 31st 05 08:39 PM Rachelle Excel Worksheet Functions 3 December 2nd 04 12:49 AM [email protected] Excel Worksheet Functions 4 November 26th 04 01:17 AM Pierre Leclerc Excel Worksheet Functions 15 November 22nd 04 12:34 AM Number Cruncher Excel Worksheet Functions 2 November 4th 04 08:52 PM

All times are GMT +1. The time now is 02:26 PM.