Jams Request Received MTH RR
Strawberry 03-Jan-12 01/01/2012
Strawberry 06-Jan-12 01/01/2012
Raspberry 10-Jan-12 01/01/2012
Raspberry 13-Jan-12 01/01/2012
Raspberry 16-Jan-12 01/01/2012
Raspberry 17-Jan-12 01/01/2012
Raspberry 17-Jan-12 01/01/2012
Raspberry 19-Jan-12 01/01/2012
Strawberry 19-Jan-12 01/01/2012
Strawberry 23-Jan-12 01/01/2012
Strawberry 27-Jan-12 01/01/2012
Raspberry 27-Jan-12 01/01/2012
Strawberry 08-Feb-12 01/02/2012
Strawberry 08-Feb-12 01/02/2012

MTH RR is a formula to return the first day of every month to be used in next tab's formula

Totals tab looks like

Month Total Strawberry Total Raspberry Total Apricot Total Blackcurrant Total
Jan-12 COUNTIF('Jobs '!C2:C110,A2)
Feb-12 13
Mar-12 23
Apr-12 1
May-12 0
Jun-12 0
Jul-12 0
Aug-12 0
Sep-12 0
Oct-12 0
Nov-12 0
Dec-12 0


(= removed from formula so you can see how I achieved total. Tab "Jobs" is the first table).

Thanks so much

C