Trying to construct an IF statement in Excel with multiple conditions

Basically I need to calculate a column that sum's previous columns only if:

• The number in column Q > 4,


• Column S = 'N' (its a 'Y' or 'N' flag in this column and I only want to sum if there is an 'N'


• P != 0 (There is a number in column P.)

This is the incorrect statement which I came up with:

=IF((Q2>4) AND (S2='N') AND (P2 != 0), V2)

(Column V contains the calculation I want to make, given that these conditions are met.

Kinda lost here guys, would really appreciate any help.

All the best.