SOLVED

New Contributor

# Incorrect sum on daily total

I have a table with daily deliveries and one column sums the trucks tonnage that came in in the row for the last truck of the day.  There is one date that gives me a sum that is almost the entire table to date.  The total for the day is 130 tons but the total I get is 13,232.  I saw this last week and removed all the formulas but went back and rewrote a formula with the same result.  All the other cells are totaling up correctly but that one date.

=IF(B525>[@Date],SUMIF(\$B\$5:H524,[@Date],\$G\$5:G524),"")

the date is june 8, 2022  (44720)

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: Incorrect sum on daily total

I'm more surprised it is working in the other cells:
=IF(B525>[@Date],SUMIF(\$B\$5:H524,[@Date],\$G\$5:G524),"")
should be
=IF(B525>[@Date],SUMIF(\$B\$5:B524,[@Date],\$G\$5:G524),"")

# Re: Incorrect sum on daily total

That did fix it.  I was using range as it is in lookup functions.  Thanks.