invoices with summary...where to start
 

I have downloaded one of the simple MS templates.

Use it daily, manually renumbering each invoice.

At the end of the month I create a separta summary adding them all up by
client...i.e. multiple summaries.

Is there some way that Excel can be automated to do the summary by client?

Thanks

invoices with summary...where to start
 

Here's one way to do it. I have summary in sheet 1 and data of clients in
sheet 2.
In sheet 2, for ex.

A B
1 Client 1 Invoice # 1
2 Client 1 Invoice # 2
3 Client 1 Invoice # 3
4 Client 2 Invoice # 1
5 Client 2 Invoice # 2
6 Client 2 Invoice # 3

For this example, in sheet 1, I will put the following formula
A1 =COUNTIFS('sheet 2'!A1:A3,"Client 1")
B1 =COUNTIFS('sheet 2'!A3:A4,"Client 2")

You could tweek it to suit your need.

Tina


"I Am Cdn" wrote:

I have downloaded one of the simple MS templates.

Use it daily, manually renumbering each invoice.

At the end of the month I create a separta summary adding them all up by
client...i.e. multiple summaries.

Is there some way that Excel can be automated to do the summary by client?

Thanks

invoices with summary...where to start
 

Sorry, made a mistake! You could actually count the whole column of clients
for the different client names. So you could put,

A1 =COUNTIFS('sheet 2'!A:A,"Client 1")
B1 =COUNTIFS('sheet 2'!A:A,"Client 2")

Tina


"T.C" wrote:

Here's one way to do it. I have summary in sheet 1 and data of clients in
sheet 2.
In sheet 2, for ex.

A B
1 Client 1 Invoice # 1
2 Client 1 Invoice # 2
3 Client 1 Invoice # 3
4 Client 2 Invoice # 1
5 Client 2 Invoice # 2
6 Client 2 Invoice # 3

For this example, in sheet 1, I will put the following formula
A1 =COUNTIFS('sheet 2'!A1:A3,"Client 1")
B1 =COUNTIFS('sheet 2'!A3:A4,"Client 2")

You could tweek it to suit your need.

Tina


"I Am Cdn" wrote:

I have downloaded one of the simple MS templates.

Use it daily, manually renumbering each invoice.

At the end of the month I create a separta summary adding them all up by
client...i.e. multiple summaries.

Is there some way that Excel can be automated to do the summary by client?

Thanks

invoices with summary...where to start
 

If you are using one of the Templates from Office Template Gallery I would
assume that each invoice is in its own separate workbook.

Is this correct?

If not, describe your scenario.

You may find some answers to automation at Ron de Bruin's site under the
Copy/Paste/Merge section.

http://www.rondebruin.nl/tips.htm


Gord Dibben MS Excel MVP

On Wed, 7 Oct 2009 10:40:12 -0700, I Am Cdn
wrote:

I have downloaded one of the simple MS templates.

Use it daily, manually renumbering each invoice.

At the end of the month I create a separta summary adding them all up by
client...i.e. multiple summaries.

Is there some way that Excel can be automated to do the summary by client?

Thanks