D
Dave Breitenbach
I would like to use named ranegs, if possible, to replace the function
SUMPRODUCT with the abbreviated nam "SP." I created the named range SP and
called it sumproduct, but I have not been able to make it work.
this function
=SP&"(--($H$4:$H$21=J5),--($F$4$F$21))"
gives me as a result
sumproduct(--($H$4:$H$21=J5),--($F$4$F$21))
but does niot give me the result of that formula.
any help would be greatly appreciated.
Dave
SUMPRODUCT with the abbreviated nam "SP." I created the named range SP and
called it sumproduct, but I have not been able to make it work.
this function
=SP&"(--($H$4:$H$21=J5),--($F$4$F$21))"
gives me as a result
sumproduct(--($H$4:$H$21=J5),--($F$4$F$21))
but does niot give me the result of that formula.
any help would be greatly appreciated.
Dave