SHEET SUMMARY FORMULA: SUM up inventory per account and associate
I need help in formulating my Sheet Summary.
On my sheet I have number of Associates with their corresponding accounts. I need to sum up the inventory per account. Ex : Jose Cruz has 3 accounts in color violet and 8 inventory.
Need to show this:
JOSE CRUZ | SM CITY/ SM NORTH EDSA /SM MEGA MALL | 8
JOSE CRUZ | PUREGOLD | 5
JOSE CRUZ | ROBINSONS / ROBINSONS 1 | 5
NINOY AQUINO | AYALA MALL / AYALA MALL 1 | 1
Help Article Resources
Check out the Formula Handbook template!