BL84
Member
Hi guys,
This is my new "Entry Sheet". The formulas I need will be directed at the tables on this sheet. I have formulas to re-direct this info to my monthly sheets. I listed simple formulas that work for 1 round in the April table. I'll need formulas that will encompass all rounds for any given table. The totals from my monthly sheets are set to go to my "Year" sheet already. This is a par 35, nine hole course. 4-3-5-4-3-4-4-4-4 = 35. I don't know how to combine criteria inside a formula at all. I couldn't come up with formulas to show you for GIR Putt or Up/Down-Made. I'll explain what's needed there to help if I can.
GIR Putt: If there is a "bullseye" (CHAR 180) the putt total needs to be counted. There were 5 GIR in "round 1", which I copied to the cells next to the April table.
U/D-M: If there is NOT a "bullseye" (CHAR 180) the Score must be <=to par for the hole.
On my "April" sheet in the score category, you can see that data is set to appear from b5:b45 on the "Pre" sheet. The b45 part is just a guess that would be adjusted. If I use this "New Pre" sheet as my data entry, I'll need a formula that adds Score C1:C? for each month. I don't want to do C1+C6+C11 etc. The video I watched earlier talks about this issue. Something like: A:C, "Score", blah blah blah. I don't know the "signs" to put in etc. If someone can get the formulas to work on this table, I should be able to figure out how to transfer that data forward.
Thanks for any help,
BL84
This is my new "Entry Sheet". The formulas I need will be directed at the tables on this sheet. I have formulas to re-direct this info to my monthly sheets. I listed simple formulas that work for 1 round in the April table. I'll need formulas that will encompass all rounds for any given table. The totals from my monthly sheets are set to go to my "Year" sheet already. This is a par 35, nine hole course. 4-3-5-4-3-4-4-4-4 = 35. I don't know how to combine criteria inside a formula at all. I couldn't come up with formulas to show you for GIR Putt or Up/Down-Made. I'll explain what's needed there to help if I can.
GIR Putt: If there is a "bullseye" (CHAR 180) the putt total needs to be counted. There were 5 GIR in "round 1", which I copied to the cells next to the April table.
U/D-M: If there is NOT a "bullseye" (CHAR 180) the Score must be <=to par for the hole.
On my "April" sheet in the score category, you can see that data is set to appear from b5:b45 on the "Pre" sheet. The b45 part is just a guess that would be adjusted. If I use this "New Pre" sheet as my data entry, I'll need a formula that adds Score C1:C? for each month. I don't want to do C1+C6+C11 etc. The video I watched earlier talks about this issue. Something like: A:C, "Score", blah blah blah. I don't know the "signs" to put in etc. If someone can get the formulas to work on this table, I should be able to figure out how to transfer that data forward.
Thanks for any help,
BL84