When might you use a SUMIFS function?

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”).

Leave a Reply

Your email address will not be published. Required fields are marked *