summing the total for every supplier

[aboiy]

Good day to all,

I have a spreadsheet with 700 rows wherein day to day
expenses are entered.
A B C D
P.Order Acct.Charge Amount Supplier
690 Staff Accom. 3,445.00 Ahmed Kanoo
697 Kit. Equipt. 525.00 Sffeco
762 Kit. Equipt. 1,749.36 Apex USA Ltd.
755 Laundry 6,279.00 Gasco
756 Kit. Equipt. 978.00 Abdullah Sawelam
864 Fuel & Gas 3,900.00 Electrolux
690 Sewage 500.25 Abdullah Sawelam
741 Fuel & Gas 1,670.00 Sffeco

Can you please provide me a formula wherein i need to make
a formula for the following:
1. get the total expenses for every supplier (col.d)
2 formula having two queries:
ex. all entries for "Abdullah Sawelam" with acct.charge
for "Kit.Equipt."only.

For your kind assistance.

Thanks and regards.


aboiy

 

[Andy B]

Hi

I would suggest using a pivot table (Data / Pivot Table) for the first
problem. This is the best way to summarise data. Here is an intro to pivot
tables:
http://peltiertech.com/Excel/Pivots/pivotstart.htm

For your second problem, you could use SUMPRODUCT:
=SUMPRODUCT((D21000="Abdullah
Sawelam")*(B2:B1000="Kit.Equipt.")*(C2:C1000))

 

[Frank Kabel]

Hi
for a formula approach you may use SUMPRODUCT:
=SUMPRODUCT(--($D$1:$D$1000="Abdullah Sawelam"),--
($B$1:$B$1000="Kit.Equipt."),$C$1:$C$1000)

you can replace the hardcoded conditions with cell
references.
But you may also consider using a pivot table for this.
See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

 

[Aboiy]

Frank & Andy,

Once again, thanks for helping me out.

Regards,

aboiy