2 Formulas to combine into CountIF's

I am trying to build a spreadsheet which I want to consolidate onto one page. I have made a Countif formula that works for counting new cars. I have made a counIF's formula that work for how many cars in each month.

What I need is a countif formula that will count new cars from a perticular month feeding from a set cel. In my spreadsheet the cells are C3 for month and C4 to select new or used.

I hope this makes sense. I'm sure its something I am missing that is simple but I have been working on it for about 1 hr.

EDIT: Should've said using the formula I am making it comes up with an error #VALUE as per cell B17 on the main screen.

Thanks for your help,

Steve

I see what you were going for with the table reference, and i'm not really sure why that wasn't working, but this seems to be.

Formula:

Please Login or Register  to view this content.

i might come back to this later to see if i can figure out why the table reference wasn't doing what it should.

****EDIT****
Immediately after posting the table references started working for me again. not sure what happened there, but the New/Used reference running form 8 to 118 instead of 5 to 118 was your problem. all ranges in the countifs formula have to be the same length. or, as was already stated, just change all of them to table references.

i just edited my comment to add that, but it was that you were running from E8:E118 while your table runs from row 5 to 118

Counting the number of New cars for a given month?

=SUMPRODUCT((TEXT(Mazda!A5:A118,"mmm")=C3)*(Mazda!E5:E118=C4))