| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing Criteria with Index - Match
On Nov 23, 4:24*am, "Roger Govier"
wrote: Hi Daniel The way I would tackle this would be to use Pivot Tables along with a VBA macro. I would have an extra data sheet with a copy of one of the sheets data, and from this construct a Dynamic Range for the Data which would be sued as the source for a Pivot Table which showed the data I wanted. In a loop in the macro, I would copy each of the 6 sets of data for the 6 sheets in turn, Refresh the Pivot and via VBA copy the data I wanted to my report sheet in the column for Q1. Continue the loop until all 6 Quarters have been covered -- Regards Roger Govier "cardan" wrote in message ... On Nov 22, 3:55 pm, "Harald Staff" wrote: Hi Don't use formulas. This is what a pivot table does. HTH. Best wishes Harald "djcmisc" wrote in message .... Hello, I am trying to figure a formula that will search a range of data and sum the values of a specific column based on the column name and row name. *I have a table of 7000+ companies listed in column B. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing days that match a criteria and date | Excel Discussion (Misc queries) | |||
| index/match, based on more than one criteria | Excel Discussion (Misc queries) | |||
| index and match on 2 criteria | Excel Worksheet Functions | |||
| Add a criteria to an Index and Match formula | Excel Discussion (Misc queries) | |||
| Summing multiple hits using match, offset and index method | Excel Programming | |||
Threaded Mode
