1st request)
Enter in D5:
=SUMIF(A2:A4,"XYZ",C2:C4)

2nd request)
Not clearly understood

HTH
--
AP


"Mandeep Dhami" a écrit dans le
message de news: ...
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