Sum VLookup() 2

[mflancour]

Is there a way to find all cells containg a string and return the total of adjacent cells? This would be much like a vlookup formula excelpt it would find more than just the first match and the returned value would be a total off all values returned.

 

[DaleWatson123321]

One option is to the the =DSUM function.

If you'd like an example, I can email you one.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[xlbo]

Have a look at the SUMIF function if there is only 1 criteria - if there are more than 1, you will need either a database function (Dale's suggestion), An array formula or a pivot table
HTH
~Geoff~

 

[mflancour]

Thanks a ton. I know this is really a vba area so I was not sure if I would get a responce. This worked great!