Thanks for all the help with the past problem which is now solved with your assistance.
I now need to increment (or decrement) the displayed value of a cell if the text in another cell/ column equals a certain value.ie A
No Club Running total No Club = 1Hope this makes sense.
Regards
Frederick
Nope...doesn't make sense to me. Keep in mind that we can't see your spreadsheet from where we're sitting, so you have to be very specific in telling us what you are trying to do.
Better examples of your data would help also.
Please click on the following line and read the instructions found via that link before posting any example data.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
can you use a count if function? =COUNTIF(range; "No Club"):: mike