To subtract values based on criteria, use the SUMIFS function to sum values that meet your criteria and then subtract this sum from your total. For example, =TotalSales-SUMIFS(SalesRange, CriteriaRange, Criteria) subtracts the sum of sales that meet a specific criterion (like a certain region) from the total sales. This method is useful for conditional calculations based on multiple criteria.