Nested If, countif, sumif, etc

[hanktate1]

Long story short having problems figuring out how to do this.

Does this look wrong or not possible?

=if(Log!D2:D1000=B2,countif(Log!Z2:Z1000,"Over"),+0)

In words
If a cell on sheet Log in the range D2-D1000 is the same as cell B2 on the current page, count the cells in column Z on the Log sheet if they equal over.

Then basically if there are no cells in the D2-D1000 range on the other page that equal B2 I want it to do nothing.

For what it is worth the cells in D2-D1000 and the B2 are text not numbers.

 

[Fluff]

Hi & welcome to MrExcel.
How about
=CountIfs(Log!D2:D1000,B2,Log!Z2:Z1000,"Over")