Data Group Total
 

Hi Mandeep

In my opinion the best way here is Pivot table, if you need you can have
tips on this web site
http://www.bettersolutions.com/excel...L115526332.htm

regards from Brazil
Marcelo


"Mandeep Dhami" escreveu:

Hello,

I have a series of data in excel spreadsheet. I have 2 request to make:

1st Request:

Some of the fields in the spreadsheet are as follow:
Column A has Name of the Company
Column B has Invoice Number
Column C has Amount of Invoice

I want a formula in Column D, which will total up all the invoice amount
against each company.
For Example: If Company XYZ has 4 invoices then on cell D5 I should get the
total of C2:C5.

This way I have got hundreds of companies and each company has tens of
invoices.

2nd Request:

Out of the total amount arrived against each company in column D above I
want to arrange them as per the amount outstanding in the range of 10000 €“
20000, 20001 €“ 30000 & 30001 €“ 40000. The arranged amount should have the
amount bifurcation as per their invoice number.

Hope to here some good solutions for the above query.

Cheers,
Mandeep