Calculate the result of a group with a formula in an excel report

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.

macro excel


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:


Interesting Management