Function "=SE" with Excel "up" only works in column? but I did not proceed in line

Question

Function "=SE" with Excel "up" only works in column? but I did not proceed in line

Asked 5 years, 8 months ago

Viewed 699 times

1

In a small table, I inserted the function "=If" with the ":", but it only works if I put the numbers with their respective colored spheres in column, when I specify what I want from the cells =se(A23:C23=2;$D$20) the result is not "waiting"but when I place in columns the cells "A23" until "C23" the result comes out correct (waiting), as I do to specify in line the cells "A23" until "C23"??

1

Try to insert the formula with Ctrl+Shift+Enter. And not only with enter, because it uses matrices.

– danieltakeshi

2018/10/17 at 18:51
Try it this way: =SE(E(A23=2;B23=2;C23=2);D20)

– R.Galamba

2018/12/27 at 09:14

1 answer

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.

by Umo • **324** points · Answer 1 · 2018-10-22T14:38:43+00:00

If by =SE(A23:C23=2;$D$20) you mean to say: check if all values are equal to 2. So, this will always be invalid, unless the sequence is in the same column and it will still only check whether the A23 is equal to 2, ignoring all other values. A correct formula for this would be =SE(CONT.SE(A23:C23;2)=CONT.VALORES(A23:C23);$D$20)