Hi Danielle,

What you need is a sumproduct formula. A sumproduct formula accepts various
criteria and gives you a count of the number of matches in your list.

Try using =SUMPRODUCT((A2:A7="EA")*(B2:B7="set")*(C2:C7))
where C2:C7 contains a 1 in each cell.

So, excel looks for an "EA" in cells A2:A7, and "set" in B2:B7 and then sums
the 1s in C2:C7.

You will love using Sumproduct !!! Try using a search engine to get more
examples of sumproduct for even more examples.

Let me know if you have any more questions (in the discussion group or send
me an email)

Cheers,
--
Kevin Lehrbass
www.spreadsheetsolutions4u.com


"Danielle" wrote:

I need a formula that will take:

Countif(a2:a7="EA" AND b2:B7="set")

Obviously this isn't a valid formula but trying to accomplish this.