I'm having trouble with writing an if statement to try and find the max value.

=IF(G31:G3000=E19,IF(H31:H3000=B22,IF(D31:D3000=B3,MAX(Q:Q),"")))

So the following will have a set value:

E19, B22, B3

And then Column Q will have all sorts of values. I want to find the max value of column Q if the previous 3 if statements are true.

I'm receiving #Value! when I try the above statement though. Any suggestions?

Thanks!