Log In
Register
Home
Active Member
January 27, 2023
Offline
Hi,
Let's assume SUMIF does not exist ...
Could a UDF replicate exactly SUMIF ?
With MySumIf (range, criteria, sumrange) as a reference "UDF Mold" , this would allow to design twisted UDFs for very specific needs.
It is mainly the way to handle the behaviour of the criteria which looks like a headache ...
Thanks a lot for your insight
Trusted Members
October 17, 2018
Offline
I'm not sure as of which version SUMIF was first introduced but the simplest way is to understand how it works and then you can write your own custom function for it. Of course this also depends on your own coding experience and knoledge but don't let that hold you back since VBA coding is in essential the same as telling the macro what you want to do
This link explains the SUMIF and SUMIFS funtions
Excel SUMIF and SUMIFS – Explained
Maybe it helps
Active Member
January 27, 2023
Offline
Hi,
Thanks a lot for the explanation on how to use SUMIF
But my objective is to replicate exactly the way SUMIF operates with a tailor-made UDF.
The main obstacle is to deal with criteria and their operators (=,<,>,<>) which can be potentially included in the definition of the criteria ...
1 Guest(s)
