Forum Discussion
Using named ranges to sum up values throughout a worksheet?
I have a workbook that has information on vehicles. Each vehicle has its own row, and the A column includes a serial number for each vehicle. Columns G and H have values for each vehicle (gallons and...
Looks like I'll need a Sumif or Sumifs function. My range is A2:A1156 and my sum_range is G2:G1156. I don't know how to write the criteria. It should amount to: "if cell in column A contains any one of the values specified in NAMED RANGE."
I'm looking for partial matches. Column A has text along with serial numbers, so a cell in column A meets criteria if it has the NAMED RANGE value anywhere in its text.