Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count IF
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count IF
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 = 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |