Particular Row Numbering

[Whylucky]

Hi All,

Im feeling kind of stupid right now, I have a code that numbers only the rows that contain a certain value. However when there is a gap i would like it to keep numbering. For example it number 1, 2, 3 then jumps a row and starts again at 5 when i would like it to be 4. Does anyone have any advice?

EQUATION:

=IF($H7<>"WIP","",COUNTA($H$7:H7))

 

[BiocideJ]

I believe COUNTIF is what you need instead of COUNTA

=IF($H7<>"WIP","",COUNTIF($H$7:H7,"WIP"))

 

[Whylucky]

That is AWESOME, thanks for the help

 

[BiocideJ]

No problem.