using SUMIF / SUMIFS

im now starting to become formula blind, help

i have 1 column with a reference to use as the identifier, "1-3" in the image, but i want to SUM up all the values in multiple columns! But the only way i can get this to work is looking at a single column for the argument rather than using the left column to then SUM up all the data within the range for the multiple columns,,,, any ideas?


Tags:

Answers