IF or SUMIF to calculate percentage of a cell based on a cell trigger

Copper Contributor

Hi There, 

I am needing help with the following

I6 - needing to calculate 5% of G6 ONLY when H6 says Y

Cheers, Bianca

 

Screenshot 2019-02-05 at 2.35.11 PM.png

2 Replies