=SUMPRODUCT(--(TEXT('Monthly Enquiries'!B2:B200,"mmmm")=B$1))
=SUMPRODUCT(--(TEXT('Monthly Enquiries'!B2:B200,"mmmm")=B$1),--('Monthly
Enquiries'!D2:D200="Yes - full proposal"))
etc.

copy across


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Peter Barker" <Peter wrote in message
...
Hi

I hope someone out there can help me as this is driving me mad!

I am trying to sort out some formulas that will pick up information from
our
monthly enquiries work sheet to provide a summary on the monthly summary
sheet. Both sheets are shown below...

Monthly Enquiries Sheet

Ref Month Client Information sent
Result

601 May-06 Wiseman Lee Solicitors Yes - Fastquote Pending
602 May-06 Threadneedle Yes - full proposal
Lost
603 May-06 Llyods Yes - full proposal Won
604 June-06 Harpers No N/A
605 June-06 Engineering & Gauge Yes - Fastquote
Pending
604 July-06 Smith & Sons Yes - full proposal
Won
604 July-06 Inmarsat No
N/A

The summary sheet is as follows...

May June July
Monthly Enquiries 3 2 2
Full Proposal issued 2 0 1
Fast Quote issued 1 1 0
Nothing issued (No) 0 1 2

Enquiries won 1 0 1
Enquiries lost 1 0 0
Enquiries pending 1 2 1
Enquiries N/A 1 2 1

Ideally I need formulaes to fill in the numbers on the second sheet
automatically based on the criteria from the first sheet.

Any help really gratefully received.

Yours hoping for some help!

Peter