Welcome Guest.

2Answers

I want to compare the two columns of date data in the excel table

Asked by: Jessica Adams 232 views Software December 3, 2018

For example, I want to count how many items of actual delivery time are later than the contract delivery time. What function is appropriate?

2 Answers

  1. +7Votes  

    As shown in the figure:

    The formula for O21 setting:

    =SUMPRODUCT(–(O3:O20>P3:P20))

    Donald Young- December 3, 2018 |

  2. +1Votes  

    加辅助Column, enter the formula = P3 > O3, and then filter with true as the filter condition.

    Walter Martin- December 3, 2018 |