Is There Still A Need for SUMPRODUCT?

[jase71ds]

Hi,
Just wondering... With modern Excel's improved abilities to handle arrays and to spill, and considering the awesome FILTER function - I'm just wondering if there is still a need that only SUMPRODUCT can fill in today's Excel world.
And if the answer is, "Yes, there are things that only SUMPRODUCT can do", could you please give a high-level example.

Apologies if this is a dumb question. I'm only an average Excel user.

Thanks for any feedback.
Jase.

 

[offthelip]

I think there still is a need for the basic sumproduct function I use it where I have list of investment values in column G, interest rates in column I , one simple sum product equation gives me the total amount of interest from all rows.

 

[jase71ds]

I guess it is simpler for numbers, as you'd have to wrap the SUM function around the FILTER function.

 

[jdellasala]

Err, how about for compatibility for people that don't have 365?