Comparing data in two columns

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

Rick Rothstein \(MVP - VB\)

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

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Two columns followed by single page-width column on same page 0
how to best represent my system adequacy data 0
Two columns : Continuous two columns vs Parallel two Column 1
Pivot Table Data Aggregation 0
Getting a value from large table. 5
Comparing Model Numbers without a giant IF statement 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0

Top