Count IF

[Glenn Robertson]

Hi,

I have a massive spreadsheet that has a number of coloums
the two main coloums are (Column B = Amount £) & (Column F
= Company). e.g.
Column B Column F
£100 Blogg Ltd
£200 Smith PLC
£300 Smith PLC
£400 Jones Ltd

I would like a macro that when clicked will look down
coloumn F and total the amount for each company e.g.

Blogg Ltd = 1
Smith PLC = 2
Jones Ltd = 1

I would also like the macro to then add the amounts for
each of the companies e.g.

Blogg Ltd = £100
Smith PLC = £500
Jones Ltd = £400

Is this possible,

Thanks

 

[Frank Kabel]

Hi
instead of using a macro have a look at pivot tables who
will create such a report for you with nearly no effort.
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

-----Original Message-----
Hi,

I have a massive spreadsheet that has a number of coloums
the two main coloums are (Column B = Amount £) & (Column

F