Maybe something like:

=sumif(a:a,333,b:b)

(Sum the values in column B where the cell in column A is equal to 333.)

jack wrote:

I would like to find every instance of a number within a given range
and then sum up values from a designated column on the same row.

--

Dave Peterson