Mathematics is pretty easy when working with Google Sheets. Addition, subtraction, multiplication. While performing operations on these, the functions work with the whole column or the cell range you specify. What if we want to give a condition at the same time while doing the addition? Then we use SUMIFS. With SUMIF we can give a condition, but with SUMIFS we can add under more than one condition. Let's move on to the explanation through examples.
https://northstaranalytics.co.uk/how-...