Trying to calculate values from cells, next to a keyword search, of an entire work book.

[CraigYoung]

Hello,

I am trying to calculate values from cells, next to a keyword search, of an entire work book.

Example
Column J of each worksheet contains a Restaurant name
Column I of each worksheet contains a numeric value spent at Restaurant

I would like a Formula to display the entire amount spent at one restaurant from the entire workbook, i.e. ... the SUM of all numeric values in Column I next to a specific keyword found in Column J

I have been trying to use VLOOKUP but have not had success, with the SUM formula and the search range

[alansidman]

You should be using the Sumifs function. Look at this link for an understanding

https://www.techonthenet.com/excel/formulas/sumifs.php