Articles Comments

Free Excel Dashboards » Dashboard, Excel Dashboard, Excel Dashboard Software, IT » Excel’s SUMIFS or SUMPRODUCT…Which is faster?

Excel’s SUMIFS or SUMPRODUCT…Which is faster?

Today, I learned about an Excel reporting need that looks something like this: There’ll be about 150,000 rows of data maintained in an Excel database. There’ll be dozens of reports, each with hundreds of different filter settings. (Different products, divisions, etc.) The data will update monthly. The reports could use either SUMPRODUCT or SUMIFS to grab the [...]

For more information visit Excel’s SUMIFS or SUMPRODUCT…Which is faster?

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software, IT

Comments are closed.