Help !!! I need to find out how many sales someone did in say Jan. I've got
this so far but it won't work with the date field..
=SUMPRODUCT((D2:D188="*01/2008")*(L2:L1880))

Many thanks in advance..

Opened Sales Person Jan Feb
08-Jan-08 Gary £1,189.11 £2,437.42
19-Dec-07 Anthony £792.81 £2,082.08
19-Dec-07 Anthony £414.06 £409.35
23-Jan-08 Stephen £276.00 £419.38
29-Jan-08 Bobby £298.15 £529.62