SUMIFS formula block

[Motherlode]

I am trying to reference a cell in my sumifs formula and I'm getting odd results.

Here's what happens:
If I type the formula like this then it gives me the correct results and works fine:
=SUMIFS($N:$N,$AF:$AF,"Active",$K:$K,AK$4,$I:$I,"Budget",$N:$N,">1000")

The problem is that instead of typing in the 1000, I want it to point to another cell where I can type in different amounts and have the formula react accordingly. It doesn't. It returns a zero every time. Here's what my formula looks like that returns the zero regardless of what I type in my cell named "Amount":
=SUMIFS($N:$N,$AF:$AF,"active",$K:$K,AJ$4,$I:$I,"Budget",$N:$N,">Amount")

I also tried the more complicated variation and still get the zero:
=SUM(IF($AF:$AF="active",IF($K:$K=AI$4,IF($I:$I="Budget",IF($N:$N>Amount,0),0))))

Anyone know what I'm doing wrong? I don't want to hard code the 1000 into the formula, I want it to reference a cell that I can change when needed. Thanks in advance!

 

[VoG]

Try

=SUMIFS($N:$N,$AF:$AF,"active",$K:$K,AJ$4,$I:$I,"Budget",$N:$N,">"&Amount)

 

[texasalynn]

welcome to MrExcel board...

try this

=SUMIFS($N:$N,$AF:$AF,"active",$K:$K,AJ$4,$I:$I,"Budget",$N:$N,">" &Amount)

 

[Motherlode]

You are the wind beneath my wings. It worked perfectly.
Thank you!