Replicate SUMPRODUCT in Power Query In my previous post, MMULT in Power Query, I showed how to recreate Excel SUMPRODUCT using List.Generate. This post will show an alternative method using List.Accumulate. Power Query does not come
Tag Archives: sumproduct
The Data A user on MrExcel Forum asked, given two columns one with a start date and one with an end date, for an excel formula to count the number of days which fall within a