I am sorry but I am still not sure. I know that I need to do a sumproduct but
I am unsure of how to set it up. When I select sumproduct it gives me the
option of three arrays. I am guessing that I need to select the fields that I
want it to check but I am unsure of how I tell it what to look for.

Lisa

"Gary Brown" wrote:

You want to use the SumProduct( ) function.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Lisa" wrote:

Dear All,

I have designed an excel database in Excel 2007, but then tried to implement
it at work only to find that the countifs function doesnt work in excel 2000.
The two columns I am trying to count have pick lists, not sure if this makes
a difference. The formula in 2007 looks like as follows
=COUNTIFS(DurhamVacs!G25:G1582,"apr",DurhamVacs!N2 5:N1582,"advertised")

What I am trying to achive is, a formula that counts where one field = Apr
and another field = advertised e.g. number of vacancies advertised in April.
I hope this make sense

Lisa