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

It ain't gonna happen. You could create a UDF called SP that invokes
SUMPRODUCT, but why would you bother.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Dave Breitenbach" wrote in
message ...
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

Although I seriously doubt the eventual utility of this approach, here
is a UDF that is a shorthand for SUMPRODUCT:

Function SP(args As String)
SP = Evaluate("SUMPRODUCT(" & args & ")")
End Function

It can be called by entering the arguments as a string e.g.

=SP("--($H$4:$H$21=J5),--($F$4:)$F$21)")

As you notice we have a single Text argument, which contains what
would otherwise be your argument list.

HTH
Kostis Vezerides

On Feb 26, 6:16 pm, Dave Breitenbach
wrote:
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

The intent was to avoid character limitations in a particular cell. But I'd
rather not use VB.

thanks anyway.

Dave

"Bob Phillips" wrote:

It ain't gonna happen. You could create a UDF called SP that invokes
SUMPRODUCT, but why would you bother.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Dave Breitenbach" wrote in
message ...
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