Formula to compare.

[srizki]

I am comparing two pivot tables, one GL has 96 rows and another one FA has some 50 rows. Some one takes entries from GL and enters it is FA. I need to see if there is any entries missing or wrong entered. For this reason I did pivot tables for both GL and FA, so it will be easy to compare. Now there are three types of entries, 1, that are in GL and not in FA, 2, In FA and not in GL, and 3, in both but different. General ID in both is key field. So far, I used these formula.
=IF(ISNA(VLOOKUP($A7,$E$5:$F$67,2,0)),0,(VLOOKUP($A7,$E$5:$F$67,2,0))) and
=IF(ISNA(VLOOKUP($E5,$A$5:$B$96,2,0)),0,(VLOOKUP($E5,$A$5:$B$96,2,0)))
To compare both the tables,

=SUMIF (H5:H96,"=0",J5:J96) and
=SUMIF (I5:I96,"=0",J5:J96)

To see the difference,
I need a formula that gets me the difference between the two values, when there are values in both, so I think I need AND IF formula.

Please help. Thanks
Please note, I post the same problem before (compare two values based on condition), but the last part is new, so this is NOT a duplicate post.

 

[srizki]

I used this array formula to add up all, but I need to formula to show the difference of individuals.
=SUM((H5:H96<>0)*(I5:I96<>0)*J5:J96)

 

[srizki]

I got the answer,
thanks to every one who read my post,
the answer is,
=IF(AND(H88<>0,I88<>0),H88-I88,"")