That is what I need to know - I been using the subtotal off the menu not the
command. Does that mean I have to enter the cell range for each reference
cause if I do this defeat the purpose. I have 1800 lines. I use the countif
and figure there is a SumIf - which there is but I cant seem to get it
correct. I have it calucating for the count but... Can you give me the
subtotal command or the correct syntext for sumif?

"Bob Phillips" wrote:

You can do that with subtotals, on a new line of course.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"klafert" wrote in message
...
I want the formula to put the total of the Individual invoices in the
Total
Invoices Paid per reference per customer.




"Bob Phillips" wrote:

Data:Subtotals should be the simplest.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"klafert" wrote in message
...
I have a spreadsheet like the example below:

Cust. Id ref # Total inv paid amout Inv# Indv.
invoice amt.

james ck# 123 500 101
250
james ck # 123 500 102
100
james ck # 123 500 103
150
Mary /r123 205 134
205
joe visa234 250 101
125
joe visa234 250 102
125


What I would like to do is subtotal or add the indivial invoice amount
on
the change of reference # for each customer with a formula or
function.
This
is going to be imported into an accounting program using Excel .csv
file.