Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the following in a spreadsheet. Everything works great except
the last column, the Total [=SUM(E3+I3+K3+M3+O3)]. The value of cell I3 is being totally ignored. Thanks for any help. Column headings: Team Name "Starting km" "Finishing km" Total km "Penalty Points Official Distance 117km 1 penalty point for Each km over/under" Start Time Finish Time Total Time "Penalty Points Official Length 175 minutes (2h 55m) 1 pt p/m if late 2 pts p/m if early" Panics opened Penalties Panics x10 "Wrong side of Envelope opened" Penalties Envelope x10 "Incorrect/Incomplete Puzzles" Penalties Puzzles x3 Totals The data: Dancer 28502 28642 =SUM(C3-B3) =IF(D3=0,0,ABS(D3-117)) 0.736805555555556 0.881944444444445 =SUM(G3-F3)*24*60 =IF(H3=0,0,IF(H3<175,(((175-H3)*2)/1440),IF(H3175,((H3-175)/ 1440),IF(H3=175,0)))) 1 =SUM(J3*10) 4 =SUM(L3*10) 0 =SUM(N3*3) =SUM(E3+I3+K3+M3+O3) Text following text between *** is cut and paste from the XL sheet *** Team Name "Starting km" "Finishing km" Total km "Penalty Points Official Distance 117km 1 penalty point for Each km over/under" Start Time Finish Time Total Time "Penalty Points Official Length 175 minutes (2h 55m) 1 pt p/m if late 2 pts p/m if early" Panics opened Penalties Panics x10 "Wrong side of Envelope opened" Penalties Envelope x10 "Incorrect/Incomplete Puzzles" Penalties Puzzles x3 Totals Dancer 28502 28642 =SUM(C3-B3) =IF(D3=0,0,ABS(D3-117)) 0.736805555555556 0.881944444444445 =SUM(G3-F3)*24*60 =IF(H3=0,0,IF(H3<175,(((175-H3)*2)/1440),IF(H3175,((H3-175)/ 1440),IF(H3=175,0)))) 1 =SUM(J3*10) 4 =SUM(L3*10) 0 =SUM(N3*3) =SUM(E3+I3+K3+M3+O3) *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I want to create a calculated item based on a calculated field | Excel Discussion (Misc queries) | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
PivotTable:Using a calculated field result in another calculated f | Excel Worksheet Functions | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) |