product if function 3 criteria

hi i have 2 criteria product if function. Its working, =PRODUCT(IF((E15:E54=74)*(F15:F54=P44);((L15:L54)^(1/365))))-1
when i add more 1 criteria function is not working =PRODUCT(IF((A15:A54=xxx)*(E15:E54=74)*(F15:F54=P44);((L15:L54)^(1/365))))-1

thx.

i did "xxx" not working.

1. remove the if
2. if xxx is a text value, it should be between quotes like "xxx", however it could work if xxx = named range, referring to a cell value

=PRODUCT(((A15:A54=xxx)*(E15:E54=74)*(F15:F54=P44);((L15:L54)^(1/365))))-1

Is that an array function? Was it confirmed with CTRL+SHIFT+ENTER instead of just enter?