Not sure exactly how your data is arranged.
If you have two columns, one containing 'New' or 'Old' (column A) and the other containing 'OTN' or 'OT7' (column B) then this formula will work for data in rows 2 to 100:
In E2 put 'Old' and in F2 put 'OTN'
In E3 put 'Old' and in F3 put 'OT7'
In E4 put 'New' and in F4 put 'OTN'
In E5 put 'New' and in F5 put 'OT7'
In G2 enter: =SUMPRODUCT(($A$2:$A$100=E2)*($B$2:$B$100=F2))
Drag the formula down to extend it to G5
You will now have the totals for the 4 'conditions'.
SUMPRODUCT works like an array formula, but does not have to be entered with the Ctrl+Shift+Enter combination.
Note that SUMPRODUCT can be extended to test for multiple items - a third column with 'In stock' or 'On order' for example.
If your data is in 4 columns:
Col. A New or blank
Col. B Old or blank
Col. C OTN or blank
Col. D OT7 or blank
Then use these 4 formulas to get the numbers:
Old & OTN =SUMPRODUCT(($B$2:$B$100="Old")*($C$2:$C$100="OTN"))
Old & OT7 =SUMPRODUCT(($B$2:$B$100="Old")*($D$2:$D$100="OT7"))
New & OTN =SUMPRODUCT(($A$2:$A$100="New")*($C$2:$C$100="OTN"))
New & OT7 =SUMPRODUCT(($A$2:$A$100="New")*($D$2:$D$100="OT7"))