ExcelBanter - Using vlookup - how can I obtain a sum of values, not just first v

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using vlookup - how can I obtain a sum of values, not just first v (https://www.excelbanter.com/excel-worksheet-functions/93513-using-vlookup-how-can-i-obtain-sum-values-not-just-first-v.html)

Terri

Using vlookup - how can I obtain a sum of values, not just first v

Bob Phillips

Using vlookup - how can I obtain a sum of values, not just first v

=SUMIF(A:A,"value",B:B)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Terri" wrote in message
...

All times are GMT +1. The time now is 06:53 AM.