How to use formula when summing an entire column with formulas?

[Pancakey]

Hello,

I have a few columns I would like to add its value together, however I am having issues getting the correct value.
If I use the sum formula SUM( ) with the column G:G in it, I get a value that is off. If I omit "=VALUE( )" from the cells in column G, I will get an error message. How do I properly sum up the total value if my cells have a formula?

=VALUE(VLOOKUP(E4,'PO Line Data UPD 11-30-23'!$1:$1048576,10,FALSE))

 

[Peter_SSs]

You have shown us a formula that refers to cell E4 in some sheet (we don't know which sheet)
The formula also refers to column A and column J of 'PO Line Data UPD 11-30-23'

You have not shown us either of the above in your image.

Your image shows us column G of some sheet. We don't know what sheet that is and in any case your formula has nothing to do with column G in any sheet.

Consequently, we don't have anything to go on. Perhaps you could show us the relevant part(s) of all relevant worksheets with XL2BB and explain again in relation to that sample data?