CountIf for multiple values on the same row

[JasonTruman]

Hi all

Anyone help (keeping it simple)

If I have a list of years in column A say lots of 2006, 2007 and 2008, then in column B, text, such as Backlog, No Backlog, is there a way using Countif to say how many are 2007 AND Backlog. I can do it using an IF combined AND in column C first to get a Yes and then count those up, but is there a way without having to do loads of calcs

Unless Countif isn't the way to go and there is another solution

Cheers

 

[Jonmo1]

=SUMPRODUCT((A1:A1000=2007)*(B1:B1000="Backlog"))

The bolded parts can be replaced with cell references containing the respective values.

 

[StephenR]

Try
=SUMPRODUCT(--(A1:A100=2007),--(B1:B100="Backlog"))

 

[JasonTruman]

Superb

Cheers guys