SOLVED

Incorrect sum on daily total

Copper Contributor

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)

 

 

 

kcalloway_0-1671115683900.png

 

kcalloway_1-1671115732767.png

 

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

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),"")

@mtarler 

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

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

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),"")

View solution in original post