Serious Problem with Formula's Result - It is reading formula instead of DATA (output)

Hello.
Ok, I will try to keep this simple.

Please see files attached.

I have a SUMIF function =SUMIF($F:$F,F3846,$G:$G)
It turns out that this formula is taking into account the formula in rubric F, instead of the output (text?).

What do I mean by this?

Column F is made out of a few formulas that outputs names.
One formula is =PROPER(D3845&" "&E3845)
The other is =PROPER(D3837)

The problem:
When my SUMIF function outputs the results, it seems to take into account the formulas themselves instead of the output text.

So I am getting wrong data in my SUMIF column. This is very bad for me.

So someone named Dan Cox will be the result of different furmulas, and therefore my SUMIF will not see him as the same person!

Is there a way to tell my SUMIF function to not look at the formula that created the name, but look only on the output text (so that Dan Cox will be Dan Cox instead of being
=PROPER(D3845&" "&E3845)
or
=PROPER(D3837)


Hope I am being clear.

Thanks so much!

Any help will be greatly appreciated.

=PROPER(D3&" "&E3) returns a space after patricia krzanich thereby ruining your results

Use
=TRIM(PROPER(D3&" "&E3))

Then your SUMIF formula shoud work