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.
|