Lists, inserting rows, and showing selective data

**WTB** · 11-10-2009, 08:52 AM

Hi,

I'm new to this and have had a look around and can't find the specific answer to my questions, so hopefully you can help.

I'm having a few basic problems with using lists. I have set up a spreadsheet with the following coloums: refrence no., name on policy, date, A premium, B premium, taken up, total premium, and brokerage. My first problem is that i would like total premium and brokerage to be automatically worked out, but only if there is a figure put into the taken up coloum. If there is nothing in the that specific row of the taken up coloum i want total premium and brokerage to remain blank in that row.
The other small problem i have is that at the bottom of some of the lists i have included a toggle total row, but not on others, now when i go to enter data it appears in different rows or doesn't allow me to type because 'cannot modify contents of total list row'.
Basically when i add a new refrence no. i want it to add a new row for the other coloums.

Thanks for the help

WTB

**rwgrietveld** · 11-10-2009, 09:16 AM

The first part is easy:
G2: =IF(F2<>"","A",""), where Column F is 'taken up'.
H2: =IF(F2<>"","A",""), where Column F is 'taken up'.
G1: total premium H1: brokerage

The "A" is something you have to define.

The second part is not completely clear to me.
The 'toggle total row' is generated automatically and cannot be adjusted other than the predefined selections like 'Count' , 'Average', etc.

Inserting a row is done using the List toolbar(View, toolbars,list)

**WTB** · 11-10-2009, 09:46 AM

Thats great, the first part is solved! Thanks, i really appreciate it.

With the second problem basically when a new refrence number is added i want all the other coloums to notice this and therefore produce a row for the policy details to be entered.
Eg. refrence number 3 is added but i want name on policy, date (this seems to be a problem as there is no toggle total row for date) ect to add a new row so the data can be filled out without me having to manually add a row for each list. Do i need to link all the toggle total rows together? so when i expand the refrence number list they all keep the same level and drop down a row? Also how can i get this to add a new row for the total premium and brokerage without having to reenter the formula? Basically similar to when you simply click and insert row i want a whole new row to appear when i add a new refrence number and don't want to have to reformat it every time. Not sure if that makes sense at all but thanks for your help.

Thanks again

WTB

**WTB** · 11-10-2009, 11:08 AM

Not to worry i figured it out. I should have made the whole spreadsheet a list instead of having each individual coloum as a list! I was trying to make things hard for myself!

Thanks

WTB