counting how many cell are not empty and does not match teir cell to the left

0

hi

i want to make a formula for an excel sheet that would count how many cell in a selection are not empty and does not match teir cell to the left. i would also need a formulas that would do the same but count it if it does not match the cell that is 2 cell to the left

Answer
Discuss

Answers

0

Please try this array formula.

=SUMPRODUCT((COUNTIF($E3:$E11,$D3:$D11)=0)*($E3:$E11<>""))

E3:E11 is the criteria range, D3:D11 is the one to the left of it. C3:C11 would be two columns to the left.

This is an array formula which must be confirmed with Ctl+Shift+Enter. If correctly confirmed it will appear between curly braces in the formula bar.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login