Summing in a VLOOKUP function

**Lesa Muir** · 12-17-2008, 10:37 AM

I have a vlookup function that is looking up a range of cells.

I would like it to look in the range and then sum up all of the values that meet the criteria.

At the moment it will only bring back the value of the first match it finds in the range, I would like it to bring back the sum of all the values it finds in the range, is this possible?

Example

Vlookup(Jan-08,$a3:$c$7,column 4 values, 0), if Jan-08 is listed in the range more than once, I would like it to add up all the values in column 4 that match.

Thanks

Lesa

**SamuelT** · 12-17-2008, 10:52 AM

Sounds like SUMIF might work in this instance?

**elcasey125** · 12-17-2008, 11:11 AM

Could you post an example of your spreadsheet.
Thank You!

**Steve R** · 12-17-2008, 11:39 AM

How to sum up specific values

**Lesa Muir** · 12-17-2008, 08:44 PM

Originally Posted by elcasey125

Could you post an example of your spreadsheet.
Thank You!

Jan-08 M77/606 North Kooly Waste dump 5.1
Apr-08 M77/606 South Kooly Waste dump 4.384
Apr-08 M77/990 South Kooly Waste dump 16.513

Apr-08

4.384 - Formula here is =IF(COUNTIF(A1:E3,A5),VLOOKUP(A5,A1:E3,5,0),0)

I have used the colours to display what the formula is referencing

At the moment the Vlookup is only selecting the 4.384 for April, I would like it to sum the 4.384 and the 16.513 as they are both for April.

thanks

Lesa

thanks

Lesa

Summing in a VLOOKUP function

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Summing in a VLOOKUP function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions