1. You defined a Named Range Analyte (from menu Formulas>Name Manager, or you simply selected the region and entered range name into Range field at top). This is not Table - you can refer to it as whole, or you can use INDEX() function to refer to part of it, but it is doesn't have any defined inner structure like Table has. As nams Analyte was used, I additionally defined a Table tAnalyte.
2. Having "=" removed from formulas didn't be any help. Now I had german function names there.
3. When you want to have some additional header rows for table, leave a hidden empty row between bottom one and rest of them. A Table can have only a single header row, and it tries to incorporate all adjacent rows and columns automatically (especially at right and at top, but better is to be on safer side).
4. Change the column header "Volumen [µl]". Table reference syntax uses square brackets, and having them in column name also may cause problems.
5. Never put any summaries at bottom of Table (or at bottom of any table)! Reserve them some rows at top of page instead! And then use Freeze Panes to keep summaries and column headers always visible. You see always table headers and totals, and you haven't to bother with adding empty rows manually, or editing your formulas when standard references are used, whenever you add some new info.
I also defined a Data Validation List for Selected column, so it is possible to enter "x", or to leave cell empty, but not anything else.
Try out: change column header "Selected" to "Gewählt", and look what happens with formulas!
|