count Two column values are equal

[jixiaoquan]

Hi everybody,

     I meet a problem,How to count how many ID which Start equals End?

     =count({<Start=End>} ID) ?

[sunny_talwar · Accepted solution]

Try this:

Count(DISTINCT {<ID = {"=Start = End"}>} ID)

[Kushal_Chawda]

Count (distinct If(Start=End, ID) )

[trdandamudi]

May be this:

=Count({$<ID={"=Start =End"}>}ID)

[#5]

=if(Start=End, count(ID) )

[jixiaoquan]

Hi Sunny ,

     Thanks a lot.You are right.

[jixiaoquan]

Hi kushal,

     Thank you for your answer.Your answer is wrong ,but I do not know why!

      The right answer is :Count(DISTINCT {<ID = {"=Start = End"}>} ID)

       Thank you very much.