• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to use the countif or sumif formula in pivot table in 2013

Hi, try to formula in pivot in calculated fields

how to use the countif or sumif formula in pivot table in 2013

IF(COUNTIFS($A$2:A2,A2,$C$2:C2,C2,$L$2:L2,">0",$M$2:M2,0,$A$2:A2,A2)>1,0,1)
 
Top