I'm currently trying to get a formula going where if 3 values are true it adds +1 to a cell. For example;

If D2 = Yes, D3 = Yes & D4 = Yes then D5 = +1 (D5 will continuously have data added to it so it should add up i.e. if I done the same formula elsewhere and the same values matched twice then the value should equal 2)

I've been using =IF but I can't seem to perfect the formula to do what I need it to.

Any help would be appreciated.