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.

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.

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.

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.

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.

No, select all the columns to be encompassed. goto DataSubtotals, select
the column to break on in 'At each change in', make sure that the 'Use
function' is Sum, and set column to be subtotalled in 'Add subtotal to'.

--
HTH

Bob Phillips

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

"klafert" wrote in message
...
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.