Sumifs Excel Formula

Ask for Help
1

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.

Sumifs Formula
Sumifs Formula1335Ă—1830 127 KB

2

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.
2 Likes
3

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

1 Like
4

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