Named function

[vtisix]

Is there a way to name a function like this?

=ROUND(SUM(SUMIF(Range1,C1,Range2)),0) where the reference C1 is relative so
that I can recall the formula with =Name(C1,0)

Any idea?

Thanks in advance.

VT

 

[Frank Kabel]

Hi
first of all you don't need the additional SUM function.
So you could use
=ROUND(SUMIF(Range1,C1,Range2),0)

If you want to 'name' a fucntion you may create a user
defined function (in VBA) but in this case I wouldn't do
this for the following reasons:
- additional overhead / lower performance
- you have to hardcode your ranges range1, range2 within
this UDF