Comparing data in two columns

  • Thread starter Thread starter Norm
  • Start date Start date
N

Norm

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing Model Numbers without a giant IF statement 2
Excel 2007 Nested formulas 2
Count if or Sum Product 7
Getting a value from large table. 5
Find total number of unique model numbers 8
Pivot Table with Data Model Connection - getpivotdata reference issue 0
VLOOKUP and Concatenation 5
Excel Comparing two columns 1

Back
Top