willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 871
- Office Version
- 365
- Platform
- Windows
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:
<tbody>
</tbody>
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
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:
<tbody> </tbody> |
<tbody>
</tbody>
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
Last edited: