Extracting only non-zero values in a collum

Please help.

I have four entry collums (A = date) (B = description) (C = account)( D = amount)
Two sets of five collums (5 diffrent accounts that can be chosen in C) the 5 first five collums fill in the amount in the propper account collum F thru J and the date is filled in L thru P , both are auto filled if the account in the header row 1 is found in the entry area C matches the heading in F-J & L-P.

I need to be able to calculate intrest and want it to be calculated on the fly (when I enter a payment or credit, so. Somehow i need to consolidate the amount collums and date collum to new sheet! and do some math there to return a value (that part I can do) I am not willing to use the if() statment over and over and over again to pull out >0 values .

current look result

0 - 100 2/6/2011
0 - 50 3/15/2011
100 2/6/2011
0 -
50 3/15/2011
0 -
0 -

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!