VLookup multiple values - sum returned values into single cell
You are Welcome!
"se7098" wrote:
Perfect!!!!! Thank you SO SO SO much!
"Teethless mama" wrote:
Try this:
=SUM(SUMIF(A:A,{"alpharetta","austin","bakersfield ","carrollton"},B:B))
"se7098" wrote:
i have multiple values to lookup...i.e., alpharetta, austin, bakersfield,
carrollton...i want to search for all of those and return the sum into a
single cell
City Customers
Alpharetta 2394
Anaheim 665
Antioch 482
Austin 356
Bakersfield 794
Boca Raton 363
Brunswick 142
Buena Park 339
Canoga Park 984
Carrollton 540
"T. Valko" wrote:
If this is what you have:
...........A.............B
1..Pittsburgh......10
2. Baltimore.......0
3..Pittsburgh......20
4..Cleveland......0
5..Cincinnati......-5
And you want to sum values that correspond to Pittsburgh:
=SUMIF($A$1:$A$5,"Pittsburgh",$B$1:$B$5)
Better to use cells to hold the criteria:
D1 = Pittsburgh
=SUMIF($A$1:$A$5,D1,$B$1:$B$5)
--
Biff
Microsoft Excel MVP
"se7098" wrote in message
...
I have found several items close to what i need but nothing exact. I need
to
perform a vlookup consisting of multiple values (names of cities) then
return
the sum of that result into a single cell. Is this possible? brand new to
vlookup so dummy it down for me, please. :)
|