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 tab...
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    Dec 15, 2022

    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
Dec 15, 2022

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
Dec 15, 2022

mtarler 

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

Resources