This sounds like a good reason to learn about pivottables.

Here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistan...lconPT101.aspx

CAYLEY01 wrote:

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

--

Dave Peterson