Automatically ID where cell information should be assigned to?

gmr4evr1, thanks for your suggestion, however that would only work if the sub was going to bowl for the regular bowler every week. There are 20 weeks and the sub would only bowl a few times for a player if at all. Placing an A in that location would make the calculation work where I wouldn't want it to. NOW, perhaps I could place an A in the area that I am suppose to put their money total.... but then I would need to add to cell "N" away to take $12 from the count and the YES in cell "M" to remain blank.

Current cell N has a function in it that reads: =IF(H8="S","",SUMIF(I8,"<>",$BI8))

and cell M has a function that reads: =IF(H8="S","",IF(I8="","",IF($B$4>BF8,"YES","")))

I still need these arguments as well.

Your requirement is not clear to me. Can you explain shortly with an example?

Here ya go sanram:

Example 1: This is what it is doing right now....

Example 1.png

Example 2: This is what I would like for it to do...

Example 2.png

In column "P" I would like to place an "A" there to mark that player as absent, which in turn will clear out the fact that she is past due & owes $12.

Current cell N has a function in it that reads: =IF(H10="S","",SUMIF(I10,"<>",$BI10))

and cell M has a function that reads: =IF(H10="S","",IF(I10="","",IF($B$6>BF10,"YES","")))

which has nothing to do with what Im wanting here, but is needed for other functions within the sheet. So if anything needs to be added to those cells, they have to include the existing formula.

Here is my current sheet if you would like to play with it.... DEMO 2.xlsm

On M10 :

Please Login or Register  to view this content.

On N10 :

Please Login or Register  to view this content.