Here is my current formula :
=SUM(IF($C232=data!$D:$D,IF('Combined Stores'!E$6=data!$H:$H,data!$F:$F,0),0))/SUM(IF($C232=data!$D:$D,IF('Combined Stores'!E$6=data!$H:$H,data!$E:$E,0),0))*100
The issue is that when referencing "data!$D:$D" & "data!$H:$H" sometime there is no data, resulting in...