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! |
Countif - Buying Frequency
See the thread two posts earlier than yours, "Counting using multiple criteria"
http://www.excelforum.com/showthread...hreadid=497726 You'll use a sumproduct of two true/false arrays. "JEFF" wrote: 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! |
Countif - Buying Frequency
Thanks!
"bpeltzer" wrote: See the thread two posts earlier than yours, "Counting using multiple criteria" http://www.excelforum.com/showthread...hreadid=497726 You'll use a sumproduct of two true/false arrays. "JEFF" wrote: 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! |
All times are GMT +1. The time now is 02:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com