Countif - Buying Frequency
Hello,
I have worksheet with customer names in column A, and the units purchased by
month in consecutive columns beginning in column B. I would like the user to
use an input cell that determined the time frame (in months). Thus, if they
put "10" in the input cell, a formula would return the number of times the
customer purchased in the last 10 months.
I am comfortable using OFFSET, but not with a COUNT function..... Any ideas?
TIA!
|