Sumif With Common Word in Range

31

=SUMIF($B$3:$B$22,"=?*is*?",$D$4:$D$24)

It will sum all cells in the range $D$4:$D$24where the word "is" exist in the range $B$3:$B$22.


Enjoy It