R
Richie
IN COL G ROW 1 I HAVE THE FOLLOWING: =A1
IN COL H ROW 1 I HAVE THE FOLLOWING: =B1
BOTH HAVE BEEN FILLED IN DOWN TO G18 AND H18 (ALL CELLS
NOW HAVE 0 IN THEM)
I TYPE IN 20 IN A1 THRU A5 AND 10 IN B1 THRU B5 AND THOSE
VALUES APPEAR IN G1 THRU G5 AND H1 THRU H5
IN G19 I HAVE =SUM(G1:G10) AND IN H19 I HAVE =SUM
(H1:H10).THIS GIVES ME THE CORRECT TOTAL.
IN G20 I HAVE =AVERAGE(G1:G10) AND IN H19 I HAVE =AVERAGE
(H1:H10) BUT I DON'T GET THE RGHT AVERAGE WHICH SHOULD BE
20 AND 10. I DETERMINED ITS THE 0's IN THE COLUMNS THAT
THROWS OFF THE AVERAGE. IF I DELETE THE ZEROS THE AVERAGE
WILL CORRECT ITSELF BUT WHEN I ENTER NUMBERS IN COL A AND
B THEY WONT CARRY OVER TO G AND H ANYMORE. DOES ANYONE
HAVE A SOLUTION TO THIS? THANKS FOR THE HELP....Richie
IN COL H ROW 1 I HAVE THE FOLLOWING: =B1
BOTH HAVE BEEN FILLED IN DOWN TO G18 AND H18 (ALL CELLS
NOW HAVE 0 IN THEM)
I TYPE IN 20 IN A1 THRU A5 AND 10 IN B1 THRU B5 AND THOSE
VALUES APPEAR IN G1 THRU G5 AND H1 THRU H5
IN G19 I HAVE =SUM(G1:G10) AND IN H19 I HAVE =SUM
(H1:H10).THIS GIVES ME THE CORRECT TOTAL.
IN G20 I HAVE =AVERAGE(G1:G10) AND IN H19 I HAVE =AVERAGE
(H1:H10) BUT I DON'T GET THE RGHT AVERAGE WHICH SHOULD BE
20 AND 10. I DETERMINED ITS THE 0's IN THE COLUMNS THAT
THROWS OFF THE AVERAGE. IF I DELETE THE ZEROS THE AVERAGE
WILL CORRECT ITSELF BUT WHEN I ENTER NUMBERS IN COL A AND
B THEY WONT CARRY OVER TO G AND H ANYMORE. DOES ANYONE
HAVE A SOLUTION TO THIS? THANKS FOR THE HELP....Richie