Sumifs Excel Formula

Hi Gliders,

I use excel formula for getting an amount of hauling trips from starting date to ending date (see image below). But, such experimental column has no numbers showed. Is there any mistake on my excel formula?

Thanks in advance.

I think you can get this with two columns.

  • If-Then-Else: If Start is before sn-Start then 0, If Finish is after sn-Finish then 0, else “Trips”.
  • Rollup the If-Then-Else column and return the sum.

thanks a lot @ThinhDinh ! :+1: :+1:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.