Share via

CountIf Function with priorities

Anonymous
2017-06-12T15:53:24+00:00

Hey. I have an issue making a log that i could use some help with.

Imagine we are in column L, a formula will check a table if a certain number is there and report back if it is true or false. (1 or 0)

The formula looks like this "=TÆL.HVIS($Y$1:$Z$20;N4)" - TÆL.HVIS =CountIF

If this turns out negative, the cell (L5 in this case) will show 0.

However if the next cell (L6) turns out positive it will show 1. Then i would need cell L5 too show 1 too. How can i implement this in the function to prioritise a 1 in the cell beneath the active cell over the countif system.

Really hope someone can help me as this is very important to me

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-06-12T16:00:35+00:00

    Something like

    =IF(TÆL.HVIS($Y$1:$Z$20;N4)=0;L6;=TÆL.HVIS($Y$1:$Z$20;N4))

    But change IF to whatever IF is in your language ;-)

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2017-06-12T20:13:28+00:00

    Try changing this setting (to checked) or convert your range to a table using Insert / Table

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-06-12T19:15:22+00:00

    Thanks very much, it's working very well now.

    One more thing. as i was editing yesterday, at some point the A through L Columns (Which are filled with formulas) started following/dublicating the cell's as i was typing the "random" number in the G column. How did i get them to do this.

    After rewriting the formulas, it has stopped doing it, but i really need it to do it.?

    Was this answer helpful?

    0 comments