**You can use the SUMIFS function to find the sum of data if the data meets a certain condition or criteria. For example, if you created conditional formatting for cells in Excel and wanted a sum of cells with a particular format, you might have a formula that looked like =SUMIFS(D1:D100,B5:B11,”purple”).**

# When might you use a SUMIFS function?

June 29, 2021June 29, 2021
0 Comment