Count if

Sorry, I can't visualise the data.

Please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Excel is correct: there are 14 instances of D54 in the range specified, not 12.

The formula you are using does not know that you only wish to count the value once in each row.

I'm not sure how to do this with a formula - there may be an array formula that will do it.

Can you explain why you think it should be 12? I reckon it should be 10 based on what you have said.

OK. Try this:

=SUM(N(MMULT(N(M2:V26="D54"),TRANSPOSE(COLUMN(M2:V26)^0))>0))

You must confirm this by clicking CTRL+SHIFT+ENTER (NOT just ENTER).

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Thanks for the rep!