sumif dynamic named range

[ajm]

how to sumif with a dynamic named range? i have several named ranges, all are dynamic using Index. I want to use a sumif at the bottom of the ranges to sum certain records. Have tried putting the range names at the head of each column and then using indirect to reference those cells but does not work. what should i be doing?

 

[StephenCrump]

SUMIF can readily incorporate dynamic ranges. For example:

	A	B	C	D
1	Type	No
2	A	2	Totals
3	B	3	A	20
4	A	5	B	80
5	B	7
6	B	11
7	A	13
8	B	17
9	B	19
10	B	23
Sheet1

Cell Formulas
Range	Formula
D3:D4	D3	=SUMIF(INDEX(MyArray,,1),C3,INDEX(MyArray,,2))

Named Ranges
Name	Refers To	Cells
MyArray	=Sheet1!$A$2:INDEX(Sheet1!$B:$B,COUNTA(Sheet1!$B:$B))	D3:D4

Perhaps you could post the example you're having trouble with?