Sumproduct with Countifs and data validation

[bradrz_2000]

I am trying to count on a number of criteria, however, the result keeps coming back as zero, and I have no idea why. It works when I use values, but not when I reference a cell, and I am very confused by this. Here is the formula:

=SUMPRODUCT(COUNTIFS(Database!E:E,3,$P:$P,{"Below"},D:D,"Male"))

This works fine and does return the correct numbers, however I need to be able to change the values I would like to count.

So when I try and change it to:

=SUMPRODUCT(COUNTIFS(Database!E:E,=L3,$P:$P,{"Below"},D:D,"=D4"))

It returns zero, despite 3 and Male being in those cells.

What very simple thing am I doing wrong.

Thank you for the help

 

[Fluff]

How about

=COUNTIFS(Database!E:E,L3,$P:$P,"Below",D:D,D4)