Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with formula
I have a worksheet that has the following labels, Name , Facility, Class,
16yd/1, 16yd/2, 16yd/3, 16yd/4, 24yd/1,24yd/2, 16 total,24 total, overall total. Te formula in the 16 total is =sum(D4:G4) which give me the total of all the 16yd shooting. in in Column D thru G the 24 Total is =Sum(H4:I4) this will give me the total for the two columns labels 24yd. OK when I put data into these 6 cells, the 16total adds as I input into the first four cells, but it also picks up the next 2 cells for the 24yd/1 and 24yd/2. The 24yd is always correct as is the Overall total, and the 16ydtotal are wrong. When I go the the formula for the 16 total after this, it changes to =SUM(D4:I4). Any help Thanks |
#2
|
|||
|
|||
Assuming you have XP (or above??), there are a couple of options:
1. change the formula to =sum($D4:$G4). 2. In Tools;Options, Edit tab: uncheck Extend List formats and formulas. I recommend 1 since 2 could have an impact on other things that you do. "Mike Busch" wrote: I have a worksheet that has the following labels, Name , Facility, Class, 16yd/1, 16yd/2, 16yd/3, 16yd/4, 24yd/1,24yd/2, 16 total,24 total, overall total. Te formula in the 16 total is =sum(D4:G4) which give me the total of all the 16yd shooting. in in Column D thru G the 24 Total is =Sum(H4:I4) this will give me the total for the two columns labels 24yd. OK when I put data into these 6 cells, the 16total adds as I input into the first four cells, but it also picks up the next 2 cells for the 24yd/1 and 24yd/2. The 24yd is always correct as is the Overall total, and the 16ydtotal are wrong. When I go the the formula for the 16 total after this, it changes to =SUM(D4:I4). Any help Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Dynamic (?) formula | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |