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
Bookmarks