I'm assuming from your description that you want the sum of those values in
Column F where Column G's value is not equal to Column E's value. Try
this...

=SUMPRODUCT((E2:E1000<G2:G1000)*F2:F1000)

Rick


"Norm" wrote in message
...
Column G contains new model #s, with a count of models in column F. Column
E
contains existing model #s, with a count of models in column D.

In many cases, the new and existing model #s are the same. I want to
compare new models numbers to existing model numbers, and only count the
number when the two don't match. The sheet has over 500 rows of data.

Any suggestions.

--
Norm