Incrementing a number based on an IF fundtion

[Dan Wilson]

Good day I am using Excel out of Office 365 on Windows10. I have a worksheet that tracks motorcycle rides. The setup is as follows:

Column A - date of a ride. formatted as date.
Column B - ride number. formatted as number with no decimal points. can go as high as three digits.
Column C - ride status. formatted as text.

What I would like to do is have a formula in Column B that examines Column C. If the data in Column C is "D" or "M" or "N", then the number in Column B is to be increased by 1. If the data in Column C is "O" or "C" or "U" then Column B is to be left either empty or have "n/a" inserted. I know how to extrapolate the number in Column B, but not with a blank or "n/a" between the sequence of numbers.

Any help is appreciated.
Thanks, Danno...

 

[Fluff]

How about, in B2 copied down
=IF(OR(C2={"D","M","N"}),MAX(B$1:B1)+1,"")

 

[Dan Wilson]

Good day Fluff. Absolutely amazing! Not only does your fix work, it taught me how include more than choice in an IF statement! This forum is the best. That one trick has saved me a lot of work.
Thank you, Danno...

 

[Fluff]

Glad to help & thanks for the feedback

 

[Dan Wilson]

Good day again fluff. After inserting your formula into my workbook, I found that apparently the formula does not want to sort along with the other formulas on the worksheet. So, the user will just have to enter the number manually. I did learn a few things in making it work though, so thanks again, Danno...