Prev: calculate number of days formula
Next: loop VBA request
From: Seeker on 25 Apr 2010 02:29
I have 3 columns contain names(unknown, may duplicated and dynamic row), date
and amount; I am looking a way to get a sum and count on data that:
1) date is equal to or greater than today, then
2) loop thru name and subtotal on each customer
3) sum subtotal if value is equal or above 10k
3) count 2) with same name treat as once
Tks

 | 
Pages: 1
Prev: calculate number of days formula
Next: loop VBA request