Matching Data over miltiple columns

[Mwelanetz]

I need some help in figuring out this.

I have a spreadsheet that will give me results showing:

a specific VIN, # of matches and average $'s for that VIN

The selection criteria is the 1st 8 #'s of the VIN, a 4 digit equipment code and a region number.

If the three identifiers match the result would count as 1. If there were more than one match, the result would be the number of matches for the selection criteria.

Can anyone help?

 

[texasalynn]

duplicate see thread
http://www.mrexcel.com/forum/showthread.php?t=379754

you don't need to start a new thread for the same topic, if the suggestions provided do not work, post back in original thread with more information

 

[pavin]

May be something like this is what you are looking for:

=SUMPRODUCT(--(A1:A11="22+Days"),--(B1:B11="Level II"),(C1:C11))

 

[Mwelanetz]

couldn't find my original. sorry bout that.

 

[Joe4]

In the future please continue on in the original posts with any clarifications or follow-ups. Normally, per forum rules, we will locked or delete questions of a duplicate nature. Since I see you went back to the old one, I will lock this one.

Have you elected to receive Email Notifications of replies to your questions? If so, you can always find your threads by clicking on the User CP menu, then going to “Subscribed Threads” and then clicking on “List Subscriptions”. This should show you all threads that you have started or replied too, with the most recent ones at the top.

If you have not elected Email Notification (so you aren’t automatically subscribed to threads), you can still find your posts using the Search functionality. Click on the Advanced Search option, and enter your User Name in the Search by User Name box, and click “Search Now”.