Need Corrections to my formulas in RED

[BL84]

Why do you want to include D:K don't you want to do calculation column wise? Column C to K corresponds to column Col N to V is't that right? You are confusing issues why you moved to avg formula now?

I copied the formula in Column C to Column D, Column E, Column F etc. That way when I entered the two "rounds", I could see if the data appeared where it was supposed to. In regards to why I went on to the average Q about Column L, I was waiting for the U/D-M formula and didn't want to waste time so I moved on to that. As I said, don't worry about answering quickly or feel pressed to get anything done. Any Q's I post can be answered at the helper's convenience. If at ANY time you don't want to help, that is okay. I'll understand you have other things to do. Sorry for these issues.

Thanks

BL84

 

[Faseeh]

Well i am comfortable with this thread, just gets confused what has been done and what has been remaining. If you are OK with the formulas that has been posted then you can tell me what is next. I think you don't need to worry about formulas that looks creepy until they are working. They can be adjusted to accommodate your data by any user on this forums.

 

[BL84]

I'm away from home right now, but I'll check to see if there is something else. I think I have most of the formulas I'll need. This Entry sheet is the important one. I won't ever need to print it, so I like the form it's in right now. The monthly sheets might need some cleaning up. You've made my stat keeping so much easier for this coming season.

Thanks Again,

BL84

 

[BL84]

Hi Faseeh,

Here's one I think needs better clarity.

=sum(if(if($b$2:$b$201="gir",c$2:c$201)=1,c$2:c$201)*($b$1:$b$200="putts")*(c$1:c$200))


The formula is set for 40 rounds of golf. I would like there to be a "running" total in the GIR-Putt row in the April table. If I've played less than 40 rounds, the data is not correct. I think one of your "0 * something" situations happens along the way. Also, what if I actually put a 0 in for putts in a cell? Will that stop the formula from doing what it's supposed to? I think the formula needs to be changed to ADDING putts. No more GIR * Putts. I'll write out what I mean.

Once again, just for the first set. If there is a 1 in the c4 cell, add the putt total in c3 to the running total in N20. If you can take out the multiplication from the formula and if GIR is met, ADD the c3 total. Does that make sense?

=sumif((b2:b10="gir",c2:c201)=1,b1:b200="putts",c1:c200))

Don't know if that makes any sense either. Hope that kind of says what I said above. Anyways, I hope you can create that formula. Seems like it would be easier than the one I had you do previously. I'll be awake for 3-4 more hours and then I'll check back tomorrow if needed.

Thanks

BL84