Array Help

I have attached the spreadsheet for those who can help.

If you scroll to the right you will be on the correct place in the sheet.(Starting with I1)


Ok one more thing and then I am done!

I built a "Amount Checker" into my budget and what I need it to do is this.

I type in a Order Number in I6 and it finds all the numbers that match from the Order column (J4:J100) than makes sure that the amount equals the Bank Amount that does not have a category or tag assigned to it and than in I8 it will say Correct or Check Again if it fails.

Example:

I type 2 in I6 and it find all the entries that start with 2 and add them and then makes sure it matches the -$40.00 because it does not have a category or tag assigned. If i need to be more clear just let me know.

I have included some example code that I used for something similiar but it does not work for this example. (I know why it doesn't just don't know how to fix it for my above problem.

=IF(I6="Blank",IF(SUM(G2:G1000)=SUM(ABS(H2:H1000)),"Blank","Blank"),IF(AND(SUMIF(B2:B1000,A4,G2:G1000)=SUM((B2:B1000=A4)*(IF(H2:H1000<0,-1,1))*H2:H1000),SUMIF(B2:B1000,A4,G2:G1000)>0),"Correct","Check Again"))