Results 1 to 7 of 7
-
10-14-2011, 10:31 PM #1
Are there any Excel formula experts here ?
I'm having trouble with a couple formulas that I just can't figure out what I'm doing wrong.
Here's the situation, I made a spreadsheet to keep track of my son's bowling scores. I have it to where I enter the 3 games and the series (3 game total), total pins (running total) and average all automatically come up. The problem I'm having is the column for total pins (F) shows the current total for any future totals when I paste it for the rest of the season. There has to be a way paste the formula so that it won't show a total until I enter that week's scores.
Here's exactly what I have :
Column A, Row 1 - date
Column B, Row 1 - 1st game
Column C, Row 1 - 2nd game
Column D, Row 1 - 3rd game
Column E, Row 1 - series
Column F, Row 1 - total pins
Column G, Row 1 - average
Columns B,C, & D Row 2 are all manually entered
Column E Row 2 - =SUM(B2:D2)
Column F Row 2 - =SUM($E$2:E2)
Column G Row 2 - =IF(COUNT(B2:D2)<>3,"",AVERAGE($B$2:D2))
Can anyone help me out ?
-
-
10-20-2011, 05:44 PM #2
Anyone ?
-
10-21-2011, 01:35 AM #3
Try this in F2:
=IF($E2=0, 0, SUM($E$2:E2))
It should show zeroes for weeks without scores.
-
-
10-21-2011, 01:41 AM #4
Doing that does show zeroes, but I don't want to see the zeroes. I want the values hidden until the scores are entered. Is there a way to do that ?
-
10-21-2011, 01:47 AM #5
Ah, in that case, this should do it for F2:
=IF($E2=0, "", SUM($E$2:E2))
It's the same double quotes as with the formula in G2. The cells remain blank if there are no scores for that week.
-
-
10-21-2011, 01:51 AM #6
That took care of it. Thank you so much for the help, I just couldn't figure out what I was doing wrong. I'm about 20 years removed from my college experience with spread sheets and looking for help on websites with posted info just wasn't getting it done for me.
-
10-21-2011, 02:34 AM #7
A mod can close or archive this, thanks.
-
Originally Posted by themanishere 
