When I was managing a sales team, I needed to calculate the total based on a specific product, by this way, I could know the trend for instance.
When I use the formula ?
To know the total of a specific group.
How to use the formula ?
The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".
How is the formula ?
This formula in F2 calculates how many PC for the group1:
This formula in F3 calculates the total of number for the group3 with android server: