Using Data Filter With Array Formula

[kumara_faith]

Hi,

I have the following table:

Book4
	G	H	I
3	State	Bonus	Increment
4	Arizona	123	10%
5	Texas	234	15%
6	New Mexico	123	5%
7	California	234	30%
Sheet1

Cell Formulas
Range	Formula
G4:G7	G4	=UNIQUE(C4:C23)
H4:H7	H4	=SUMIF($C$4:$C$23,G4,$D$4:$D$23)
Dynamic array formulas.

I would like to use Data Filter to sort each columns. However, when I use data filter, Excel says cannot use filter with an array. My actual table is very long and is there a way to use data filter with an array formula in the table ?

 

[kumara_faith]

Thank you Jason. Appreciate it and have a wonderful day.