I am trying to write a formula that will search a worksheet and give me the
total number of units that were completed in a given month, i.e.,

Type Serial # Status RMA # Date Out

M50 22917 On Shelf 60016 18-Apr-07
M65 33836 On Shelf 60426 20-Apr-07
M50 11122 On Shelf 60435 24-Apr-07
AirNet301 12970 On Shelf 60592 25-Apr-07
M65 30631 On Shelf 60536 27-Apr-07
M65 34135 On Shelf 60537 27-Apr-07
MN W/P 36520 On Shelf 60593 30-Apr-07
MN W/P 34767 On Shelf 60625 30-Apr-07
AirNet301 12973 On Shelf 60639 1-May-07
MiniNet310 42419 On Shelf 60640 2-May-07

I have been trying the CountIf statement and trying to combine that with the
and/if statements and I am getting knowhere...

I just need to find out how many units, by type, were done in the month.

Thank you for any help that you can give me.

Rod