How to Do Countifs/Sumifs in PowerQuery M.Language Formulas?

Question

Is it possible to Do Excel's Countifs/Sumifs formulas in powerquery Formulas? Let's Say I have [Column1] as "Criteria range" and [Column2] as "Criteria" (Example criteria [Column2] text contains "Product") and I want Count/Sum [Column1] Cells in the new custom column ([Column3])

Answer 1

This formula can be used:

List.Count(List.FindText(Source[Column1], [Column2]))

It counts the number of records in column 1 that contain the word that stands in the current row of column2.