Countifs for repeated cell combinations

[willow1985]

Hello,

I have been trying to figure out a formula that will count how many times a particular part has been in our facility. Parts are identified by part number and serial number so I need to count the combination of the 2.

Example:
[TABLE="width: 301"]
<tbody>[TR]
[TD][TABLE="width: 439"]
<tbody>[TR]
[TD]part_number[/TD]
[TD]serial_number[/TD]
[TD]Amount of Times Through facility[/TD]
[/TR]
[TR]
[TD]989898
545454[/TD]
[TD]M001
N123[/TD]
[TD]2
0[/TD]
[/TR]
[TR]
[TD]989898[/TD]
[TD]M001[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I tried using the following countif formula but it gives me a result of 0 for everything.

=COUNTIFS(E2:E1000,F2:F1000)


Also if an additional condition could be added not to count Any Cell that says "NSN" in column F

Any help would be appreciated.

Thank you

Carla

 

[joshman108]

I believe you are looking for:

=countifs(e:e,e:e,f:f,f:f)

What this does is say: "how many times in the entire column of E do we see this particular value? AND how many times in F do we see the corresponding value in F?" This will search for them jointly, acting like they are a single field.

 

[willow1985]

This works perfect, but is there a way to add the condition do not count any cell that ="NSN"?