In Excel, to conditionally calculate total, I will use the SUM function that sums up the numbers.
The following dataset contains 4 unique phone models and each model's instance is repeated multiple times in column B. Column C contains quantity of each one as shown below:
![Dataset Dataset](https://kunalexceltip.com/wp-content/uploads/2024/03/Dataset-4.png)
Now I want to conditionally calculate the total quantity of each unique phone model using the SUM function:
![Dataset Dataset](https://kunalexceltip.com/wp-content/uploads/2024/03/Dataset-5.png)
To accomplish the task, I create named ranges; one for the Phone column and the other for Qty column, like shown below:
![Creating named ranges Creating named ranges](https://kunalexceltip.com/wp-content/uploads/2024/03/Creating-named-ranges-3.gif)
After this, I construct my conditional SUM formula in F2 and drag the fill handle down to copy the formula to the rest of the cells like shown below:
![Constructing conditional SUM formula Constructing conditional SUM formula](https://kunalexceltip.com/wp-content/uploads/2024/03/Constructing-conditional-SUM-formula.gif)
Therefore, I get the total quantity of each unique phone model using the SUM function conditionally. I hope this post helped you.