Perhaps it is your data that is at fault - do you have some numbers
that are really text values that look like numbers?

You can try entering:

=ISNUMBER(A1)

in a helper cell (assumes A1 contains your number - adjust to suit),
and then copy down. It should return TRUE.

Hope this helps.

Pete

On Oct 6, 12:58 am, RFTKaiser
wrote:
I have created a SUMIF formula that appears to be correct, but continues to
return a "#Value!" in the field I have created the formula. If I look at the
area where the different pieces are filled in the correct answer is appearing
there, but the "#Value!" still is all I see in the field on my Excel
spreadsheet.

I went online to look for help there and I am already incorporating their
suggestions. I am looking to see if there is anyone out there that can
possibly look at the formula I have to provide some suggestions.

Thank you!