F
F.G.
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")*(nra!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
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")*(nra!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