Can we use a Row number as the start counter in the Countif function?

[nickmsi]

When we get a cell trigger, like when a "2" appears in a certain Cell I need to change the start counter in Countif as follows:

At row 15 I need something like these:

If(ao14=2,countif($A$(row15):$A15,C$5),countif($A$5:$A15,c$5)) or

If(ao14=2,countif($A$(B15):$A15,C$5,countify($A$5:$A15,C$5))

The end formula that I need is:

If(ao14=2,countif($A$15:$A15,C$5),countif($A$5:$A15,C$5))

Every time we get a 2 we need to resent the starting counter in the Countif to the next row.

Is it possible to do this?

 

[nickmsi]

I solved the problem by using a different counter as follows:

IF(AND($CI150=2,$A151=AW$4),1,IF(AND($CI150=2,$A151<>AW$4),0,IF($A151=AW$4,AW150+1,AW150)))

Cheers

 

[Macropod]

Cross-posted at: https://www.excelforum.com/excel-fo...dd-a-row-number-to-a-formula.html#post5097776
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[nickmsi]

I read the post.

Thanks