software

I am a fairly new excel user. I am a contractor and wish to find out how many
estimates we send out weekly from a dated list. We typically have many
estimates daily and wish to determine over a specific amount of time the
number of estimates.
I'm sure this is an easy one, once again fairly new at this.

Thanks much for the help

try a sumproduct formula
=sumproduct((a4:a22gt;=a1)*(a4:a22lt;a2))

--
Don Guillett
SalesAid Software

quot;jrheinschmquot; gt; wrote in message
...
gt;I am a fairly new excel user. I am a contractor and wish to find out how
gt;many
gt; estimates we send out weekly from a dated list. We typically have many
gt; estimates daily and wish to determine over a specific amount of time the
gt; number of estimates.
gt; I'm sure this is an easy one, once again fairly new at this.
gt;
gt; Thanks much for the help
=SUMIF(A:A,quot;gt;=quot;amp;first_date)-SUMIF(A:A,quot;gt;quot;amp;second_date)

where column A holds your dates and first_date and second_date are cell
references to those respective dates.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jrheinschmquot; gt; wrote in message
...
gt; I am a fairly new excel user. I am a contractor and wish to find out how
many
gt; estimates we send out weekly from a dated list. We typically have many
gt; estimates daily and wish to determine over a specific amount of time the
gt; number of estimates.
gt; I'm sure this is an easy one, once again fairly new at this.
gt;
gt; Thanks much for the help
Don,
How very simple is my mind, or very complex is yours. You R the man! It of
course does what I need, Thanks

quot;Don Guillettquot; wrote:

gt; try a sumproduct formula
gt; =sumproduct((a4:a22gt;=a1)*(a4:a22lt;a2))
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;jrheinschmquot; gt; wrote in message
gt; ...
gt; gt;I am a fairly new excel user. I am a contractor and wish to find out how
gt; gt;many
gt; gt; estimates we send out weekly from a dated list. We typically have many
gt; gt; estimates daily and wish to determine over a specific amount of time the
gt; gt; number of estimates.
gt; gt; I'm sure this is an easy one, once again fairly new at this.
gt; gt;
gt; gt; Thanks much for the help
gt;
gt;
gt;

glad it helped--
Don Guillett
SalesAid Software

quot;jrheinschmquot; gt; wrote in message
...
gt; Don,
gt; How very simple is my mind, or very complex is yours. You R the man! It of
gt; course does what I need, Thanks
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt;gt; try a sumproduct formula
gt;gt; =sumproduct((a4:a22gt;=a1)*(a4:a22lt;a2))
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;jrheinschmquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I am a fairly new excel user. I am a contractor and wish to find out how
gt;gt; gt;many
gt;gt; gt; estimates we send out weekly from a dated list. We typically have many
gt;gt; gt; estimates daily and wish to determine over a specific amount of time
gt;gt; gt; the
gt;gt; gt; number of estimates.
gt;gt; gt; I'm sure this is an easy one, once again fairly new at this.
gt;gt; gt;
gt;gt; gt; Thanks much for the help
gt;gt;
gt;gt;
gt;gt;
Now I need to add to what You've helped me with.
Determine how many dates are in a specific date range, but only if another
column shows a 1 instead of a 2 ??

quot;Don Guillettquot; wrote:

gt; glad it helped
gt;
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;jrheinschmquot; gt; wrote in message
gt; ...
gt; gt; Don,
gt; gt; How very simple is my mind, or very complex is yours. You R the man! It of
gt; gt; course does what I need, Thanks
gt; gt;
gt; gt; quot;Don Guillettquot; wrote:
gt; gt;
gt; gt;gt; try a sumproduct formula
gt; gt;gt; =sumproduct((a4:a22gt;=a1)*(a4:a22lt;a2))
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Don Guillett
gt; gt;gt; SalesAid Software
gt; gt;gt;
gt; gt;gt; quot;jrheinschmquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I am a fairly new excel user. I am a contractor and wish to find out how
gt; gt;gt; gt;many
gt; gt;gt; gt; estimates we send out weekly from a dated list. We typically have many
gt; gt;gt; gt; estimates daily and wish to determine over a specific amount of time
gt; gt;gt; gt; the
gt; gt;gt; gt; number of estimates.
gt; gt;gt; gt; I'm sure this is an easy one, once again fairly new at this.
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks much for the help
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

A B C D E F
1 3/21 1
2 3/28 1
3 4/15 2
4 4/18 1
5 1/28 2
6 2/15 1
7 2/28 1

Dates to count 2/28 - 4/18 but only if D is 1. the answer would be 4?

quot;jrheinschmquot; wrote:

gt; Now I need to add to what You've helped me with.
gt; Determine how many dates are in a specific date range, but only if another
gt; column shows a 1 instead of a 2 ??
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt; gt; glad it helped
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Don Guillett
gt; gt; SalesAid Software
gt; gt;
gt; gt; quot;jrheinschmquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Don,
gt; gt; gt; How very simple is my mind, or very complex is yours. You R the man! It of
gt; gt; gt; course does what I need, Thanks
gt; gt; gt;
gt; gt; gt; quot;Don Guillettquot; wrote:
gt; gt; gt;
gt; gt; gt;gt; try a sumproduct formula
gt; gt; gt;gt; =sumproduct((a4:a22gt;=a1)*(a4:a22lt;a2))
gt; gt; gt;gt;
gt; gt; gt;gt; --
gt; gt; gt;gt; Don Guillett
gt; gt; gt;gt; SalesAid Software
gt; gt; gt;gt;
gt; gt; gt;gt; quot;jrheinschmquot; gt; wrote in message
gt; gt; gt;gt; ...
gt; gt; gt;gt; gt;I am a fairly new excel user. I am a contractor and wish to find out how
gt; gt; gt;gt; gt;many
gt; gt; gt;gt; gt; estimates we send out weekly from a dated list. We typically have many
gt; gt; gt;gt; gt; estimates daily and wish to determine over a specific amount of time
gt; gt; gt;gt; gt; the
gt; gt; gt;gt; gt; number of estimates.
gt; gt; gt;gt; gt; I'm sure this is an easy one, once again fairly new at this.
gt; gt; gt;gt; gt;
gt; gt; gt;gt; gt; Thanks much for the help
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt;
gt; gt;
gt; gt;

=sumproduct(--(a4:a22gt;=a1),--(a4:a22lt;a2),--(D422=1))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jrheinschmquot; gt; wrote in message
...
gt; A B C D E F
gt; 1 3/21 1
gt; 2 3/28 1
gt; 3 4/15 2
gt; 4 4/18 1
gt; 5 1/28 2
gt; 6 2/15 1
gt; 7 2/28 1
gt;
gt; Dates to count 2/28 - 4/18 but only if D is 1. the answer would be 4?
gt;
gt; quot;jrheinschmquot; wrote:
gt;
gt; gt; Now I need to add to what You've helped me with.
gt; gt; Determine how many dates are in a specific date range, but only if
another
gt; gt; column shows a 1 instead of a 2 ??
gt; gt;
gt; gt; quot;Don Guillettquot; wrote:
gt; gt;
gt; gt; gt; glad it helped
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Don Guillett
gt; gt; gt; SalesAid Software
gt; gt; gt;
gt; gt; gt; quot;jrheinschmquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; Don,
gt; gt; gt; gt; How very simple is my mind, or very complex is yours. You R the man!
It of
gt; gt; gt; gt; course does what I need, Thanks
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Don Guillettquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt;gt; try a sumproduct formula
gt; gt; gt; gt;gt; =sumproduct((a4:a22gt;=a1)*(a4:a22lt;a2))
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; --
gt; gt; gt; gt;gt; Don Guillett
gt; gt; gt; gt;gt; SalesAid Software
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; quot;jrheinschmquot; gt; wrote in
message
gt; gt; gt; gt;gt; ...
gt; gt; gt; gt;gt; gt;I am a fairly new excel user. I am a contractor and wish to find
out how
gt; gt; gt; gt;gt; gt;many
gt; gt; gt; gt;gt; gt; estimates we send out weekly from a dated list. We typically have
many
gt; gt; gt; gt;gt; gt; estimates daily and wish to determine over a specific amount of
time
gt; gt; gt; gt;gt; gt; the
gt; gt; gt; gt;gt; gt; number of estimates.
gt; gt; gt; gt;gt; gt; I'm sure this is an easy one, once again fairly new at this.
gt; gt; gt; gt;gt; gt;
gt; gt; gt; gt;gt; gt; Thanks much for the help
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;