Invoices
Hi,
If you are looking to summarize the charges by address assuming that your
data with your address are in column A and your charges in column B and then
in column D you have all the address and in column E you want to summarize
them use
=sumproduct(--(D2=$A$1:$A$10000),$B$1:$B$10000)
change range to fit your needs, copy formula down
"suewalton21" wrote:
I have a worksheet for 37 addresses, showing various charges
I need to produce a single invoice for each address
Any help please
|