HLookup with Count

[Mearsy]

Hi, hoping someone can help me please. I want to be able to reference the current month on a separate sheet and count the relevent rows against the relevant month, so if the current month is May 15, I want be able to look up May 15 and count how many rows against each section, e.g. how many rows in MPG for May 2015 (answer = 5). I've attached a sample spreadsheet.
Many thanks in advance.

[Special-K]

What happens if a row contains 0 or blank against the month, does it get counted or not?

[Mearsy]

I want to count every row that contains a number even if it's 0

[Special-K]

Then the month is immaterial since MPG has 5 rows for EVERY month

Try this
=COUNTIF(Data!A1:V1,TEXT(A1,"mmm yyyy"))*COUNTIF(Data!A2:A39,"MPG")

If the month does not exist in the top row then the result will be zero otherwise the number of rows will be counted.
NOTE: Your month in sheet "Current Month" is a date but the month headings in data are actually text, hence the TEXT conversion.

[JohnTopley]

AS MPG is in Colum A it (apparently) applies to ALL months in your sample why is the figure for May different to any other. I note in December there is a blank cell in one of the MPG rows: does this mean the count of MPG for December is 4?