Forum Discussion

kcalloway's avatar
kcalloway
Copper Contributor
Dec 15, 2022
Solved

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

  • mtarler's avatar
    mtarler
    Silver 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),"")

    • kcalloway's avatar
      kcalloway
      Copper Contributor

      mtarler 

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

Resources