I'm hoping to not also have to use a formula indicating a name in there, if that makes sense:

The above quote concerns me. Do you have the name's listed in this
summary area as a row/column label? The formula could simply reference
this label rather than having the name right in the formula. Maybe
that's what you mean.

Say, this is in E1:
=SUMPRODUCT(--(A1:A100=D1)*B1:B100)

Where D1 is the label "Janet" or "Jon" or whatever. The A column range
can just include the entire length of data, it doesn't matter if some
are blank or month names or whatever.