Hello,

Is it possible to use sumproduct for labels (named ranges)?

I tried this formula without success:
=SUMPRODUCT((Label1="A")*(Label2="S")*(Label3=0))

I’ve tried to use it jointly with countif:
=Sumproduct((countif(Label1,”A”))*((countif(label2 ,”S”))*(countif
(Label3,0)))
It doesn’t return the correct results.

I know that if I use the range instead of labels the function works:
=SUMPRODUCT((nra!E2:E659="A")*(nra!F2:F659="S")*(n ra!G2:G659=0))

But because of repetitiveness of the function in different ranges over
time I was wondering if there is a way to make it work with labels.

Thank you,
Frank Gashi