Forum Discussion
kcalloway
Dec 15, 2022Copper 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)
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),"")
- mtarlerSilver Contributor
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),"")