Hi Max,

Both the options are not working for me.


"Max" wrote:

"Arjuna" wrote:
... better to use sum(if(...)) [slightly corrected] ...

Why better <g? Perhaps as another option here, and its always good to know
of alternative ways to get things up .. imo, SP doesn't require
array-entering (except with TRANSPOSE nested within), and it is equally, if
not more directly intuitive to understand than the array-entered
Sum(if(...)). And ... it's easier to "forget" to array-enter /
re-array-enter an array formula than it is to use one which is entered
"normally"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---