I need Your help.

I am looking for a solution, where I can do the following:

I have a table, where I want to build a SUMPRODUCT formula, with multiple conditions.

I am already OK with the conditions, but in the table I do have a column (Named: Weighting), where I have % values.

On my sheet I do have a checkbox, and if it is checked, the connected cell (name this: ChB_Weighting) shows TRUE, if unchecked, of course FALSE.

I would like to have a formula, which can understand this, and if this cell shows TRUE, then my formula will be something like this:

=SUMPRODUCT(MyValues*(CriteriaCol="apple")*Weighting), so all my values are multiplied by the weighting column.

BUT

If there is FALSE, then the same, but WITHOUT the Weighting part, like:

=SUMPRODUCT(MyValues*(CriteriaCol="apple"))

One solution would of course be: =IF(ChB_Weighting=TRUE;SUMPRODUCT(MyValues*(CriteriaCol="apple")*Weighting);SUMPRODUCT(MyValues*(CriteriaCol="apple")))

But is there a more elegant one too? And especially, because there may be more Checkbox on the sheet, so it would be great, if one checkbox could turn on or off one single condition/array.

How would it be possible? Or what kind of solution would You recommend, to be able to make my sheet more flexible, and user friendly?

Any help is greatly appreciated!

Thank You All!

Best Wishes,

Zsolt (from Hungary <- This may be the reason for my typo mistakes, if there are some )