software

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 quot;10quot; 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!See the thread two posts earlier than yours, quot;Counting using multiple criteriaquot;
www.excelforum.com/showthread...hreadid=497726
You'll use a sumproduct of two true/false arrays.

quot;JEFFquot; wrote:

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

Thanks!

quot;bpeltzerquot; wrote:

gt; See the thread two posts earlier than yours, quot;Counting using multiple criteriaquot;
gt; www.excelforum.com/showthread...hreadid=497726
gt; You'll use a sumproduct of two true/false arrays.
gt;
gt; quot;JEFFquot; wrote:
gt;
gt; gt; Hello,
gt; gt;
gt; gt; I have worksheet with customer names in column A, and the units purchased by
gt; gt; month in consecutive columns beginning in column B. I would like the user to
gt; gt; use an input cell that determined the time frame (in months). Thus, if they
gt; gt; put quot;10quot; in the input cell, a formula would return the number of times the
gt; gt; customer purchased in the last 10 months.
gt; gt;
gt; gt; I am comfortable using OFFSET, but not with a COUNT function..... Any ideas?
gt; gt;
gt; gt; TIA!
gt; gt;