Combining Vlookup & COUNTIF

[Help!]

I need help with a formula to summarise some data. I have columns of data as such...

Kettering Complete
Northants N/A
Kettering Complete

What i need the formula to do is, look down column A for all the Ketterings and return the NUMBER that says "complete" in column B.

Any Help is much appreciated.

 

[Excelestial]

=countifs(a:a,"ketterings",b:b,"complete")

 

[T. Valko]

I need help with a formula to summarise some data. I have columns of data as such...

Kettering Complete
Northants N/A
Kettering Complete

What i need the formula to do is, look down column A for all the Ketterings and return the NUMBER that says "complete" in column B.

Any Help is much appreciated.

Try one of these...

Use cells to hold the criteria:

• D2 = Kettering
• E2 = Complete

This formula will work in ALL versions of Excel:

=SUMPRODUCT(--(A2:A10=D2),--(B2:B10=E2))

This formula will work in Excel 2007 and later:

=COUNTIFS(A2:A10,D2,B2:B10,E2)

 

[Help!]

It works Thanks! - Didnt realise it was that easy!