View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Work around Calculated Field limitation

Dump the Pass field into the data area 3 times.
Then set the field options as :Sum/Count/Average
Name the fields Passed/Taken/Success%

that should solve it.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Tod" wrote:

Instance Name Pass Fail
123 Joe 1 0
124 John 1 0
125 Bill 0 1
126 Joe 1 0
127 Bill 1 0
128 Lucy 0 1