EXCEL SUMIF OR SUMPRODUCT?

Update: I HAVE TWO COLUMN WHERE A1-200,A2-300,A3-400,A4-500
AND B1-10,B2-30,B3-20,B4-50 I WANT TO SUM THE RANGE " A"
IF "B" IS EQUAL TO 5% OF "A"
HOW ....?
1 answer 1