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)

Cross post. other username http://www.excelguru.ca/forums/showt...late-Frequency
http://www.excelforum.com/excel-form...frequency.html

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post