Hi
I am trying to count only if both criteria are met I do not have countifs
available and also tried to use sumproduct which does not seem to work
either...
heres what I need to do
first range = B16-B1000 (contains different Status such as Won Job)
Second range =C16:C1000 (contains months)

I need to count numbers of each status for example Won Job for Jan..all way
through to Dec for the different statuses that I have

Jan Feb March
At Tender
Client Not Interested
Competitor Appointed
Letter Sent
Project On Hold
Quoted
Won Job
Total New Leads


I have set the calculations at the top of the worksheet to look like above
--

Kind Regards
Michelle