1. I have a field where I would like to know the last # used.

If your #'s are sequential then the last entry will be the MAX value of the
range.

=MAX(A1:A100)

2. I need to have total amount $$ (inc neg amounts)

=SUM(B:B)

3. I need to know how many are TBA

=COUNTIF(B:B,"TBA")

4. I need to know how many are No Costs.

=COUNTIF(B:B,"No Costs")


--
Biff
Microsoft Excel MVP


"Redsphynx" wrote in message
...
Hi, this is my scenario...

I have a table with 2 (more but they are irrelevant) columns:
Column # and GST

In the # Column I have numbers 1, 2, 3 etc and I manually increase it by
one
every time I insert another row. In column GST on the same row as # I have
a
$$ amount that I put either $$$, TBA or 'Not Costs'.

e.g. 1 = $5.00, 2 = TBA, 3 = -$6.00 4 = No Costs 5 = $2.00, 6 = No Costs
etc.

Now, my questions are...
1. I have a field where I would like to know the last # used.
2. I have another field where I need to have total amount $$ (inc neg
amounts)
3. I have another field where I need to know how many are TBA
4. I have one final field where I need to know how many are No Costs.

Thanks in advance for everyones help.
Redsphynx