Conditional sum in Excel - Excel Tips and Tricks

Learn how to do a conditional sum in Excel. I will also show you how to do a sum of a column in Excel with multiple conditions.

Here are the formulas featured in the video.

Single Criteria
Add Total For All Fig
=SUMIF(C6:C28,"fig",G6:G28)

Single Criteria With Wildcard
=SUMIF(C6:C28,"*fig*",G6:G28)

Multiple Criteria
=SUMIFS(G6:G28,C6:C28,"fig",E6:E28,"＞800")

Multiple Criteria With Wildcard
=SUMIFS(G6:G28,C6:C28,"*fig",E6:E28,"＞800")

#tip #excel #microsoft #shorts #shortvideo #shortsvideo #howto #how #google