Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 18th 05, 09:49 PM
Telly
 
Posts: n/a
Default 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   Report Post  
Old February 18th 05, 11:17 PM
Jason Morin
 
Posts: n/a
Default

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.
.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"criteria" in a sumif refering to the value in another cell mark Excel Discussion (Misc queries) 1 January 31st 05 08:39 PM
How do I ask for multiple criteria when creating a "sumif" formul. Rachelle Excel Worksheet Functions 3 December 2nd 04 12:49 AM
SUMIF with more than 1 criteria [email protected] Excel Worksheet Functions 4 November 26th 04 01:17 AM
Forget SUMIF, COUNTIF and VLOOKUP Pierre Leclerc Excel Worksheet Functions 15 November 22nd 04 12:34 AM
Can I use a cell reference in the criteria for the sumif function. Number Cruncher Excel Worksheet Functions 2 November 4th 04 08:52 PM


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

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017