vLookup to Count Number of Completed Category Items for Report

In C2, for example, copied down
=COUNTIFS('Data (Month)'!$E:$E,"Business",'Data (Month)'!$B:$B,B2,'Data (Month)'!$D:$D,"Completed")

In D2
=COUNTIFS('Data (Year)'!$E:$E, "Business",'Data (Year)'!$B:$B,B2,'Data (Year)'!$D:$D,"Completed")

You might want to split the header into two cells (Month) or (Year) in one and the catagory in the other. That way you won't need to hardcode in "Business", you can just refer to C$1.
Make sense?

What's the difference between tabs Data (Month) and Data (Year)? In reality, there will be a different Data (Month) for each month and then Data Year will be all months of 2015 (for example)?
Which brings me to the question, where do you want the completed items per month pulled from? Month? Year? or both?

Thanks for getting back.

The Data (Month) is just a subset of the Data (Year)... so, I would think the Data (Year) would be the source.

Oh, and here's the formula I was trying for January... I think I'm close???
=COUNTIFS('Data (Year)'!$E:$E, 'Data (Year)'!$B:$B,B2,'Data (Year)'!$D:$D,"Completed", 'Data (Year)'!$F;$F, ">="01/01/2015, 'Data (Year)'!$F:$F, "<"01/30/2015)




Thanks

Okay, first I modified the headers L1 to Q1 to be actual dates (i.e. 2/1/2015) but formatted as mmmm yyyy

Then in L2 copied across and down
=SUMPRODUCT(--('Data (Year)'!$B$2:$B$1000=$B2), --( 'Data (Year)'!$D$2:$D$1000="Completed"), --(MONTH( 'Data (Year)'!$F$2:$F$1000) =MONTH(L$1)))
Note, I didn't include row 1 of Data Year as it would generate an error when using the MONTH function.
Does that work for you? Questions?