• 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.

COUNTIF which relates the number of columns

bines53

Active Member
Hello friends !

I have a problem with the formula, which relates the number of columns.
With one column =AGGREGATE(15,6,$F$2:$F$31/(COUNTIF($F$2:$F$31,$F$2:$F$31)=J2),1+SUMIF(J$1:J1,J2)),the function COUNTIF work.
Which relates the number of columns
=AGGREGATE(15,6,MMULT($A$2:$D$31,{1;1;1;1})/(COUNTIF(MMULT($A$2:$D$31,{1;1;1;1}),MMULT($A$2:$D$31,{1;1;1;1}))=J2),1+SUMIF(J$1:J1,J2)) ,says, there is a mistake in the formula.
Unable to enter this section MMULT($A$2:$D$31,{1;1;1;1}) in COUNTIF .
The formula in cell M2.

Thank you !
 

Attachments

  • TEST.6.xlsx
    10 KB · Views: 10
Back
Top