Hi Everyone



I have a table of cash machines and the its usage. Grateful if anyone can any help with a formula to calculate the number of visits made by the various types of cards at each of the ATM over the period, with a breakdown of x1 , x2 , x3 , x4 , x5 , >5. Ideally I want to use a formula so that other colleagues could know how it was calculated. Please see the attached sample.


Many thanks in advance

Attached Files

Book1.xlsx (12.7 KB, 9 views)