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:a22=a1)*(a4:a22<a2))

--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
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

=SUMIF(A:A,"="&first_date)-SUMIF(A:A,""&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)

"jrheinschm" wrote in message
...
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

Don,
How very simple is my mind, or very complex is yours. You R the man! It of
course does what I need, Thanks

"Don Guillett" wrote:

try a sumproduct formula
=sumproduct((a4:a22=a1)*(a4:a22<a2))

--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
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

glad it helped


--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
Don,
How very simple is my mind, or very complex is yours. You R the man! It of
course does what I need, Thanks

"Don Guillett" wrote:

try a sumproduct formula
=sumproduct((a4:a22=a1)*(a4:a22<a2))

--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
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

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 ??

"Don Guillett" wrote:

glad it helped


--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
Don,
How very simple is my mind, or very complex is yours. You R the man! It of
course does what I need, Thanks

"Don Guillett" wrote:

try a sumproduct formula
=sumproduct((a4:a22=a1)*(a4:a22<a2))

--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
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

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?

"jrheinschm" wrote:

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 ??

"Don Guillett" wrote:

glad it helped


--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
Don,
How very simple is my mind, or very complex is yours. You R the man! It of
course does what I need, Thanks

"Don Guillett" wrote:

try a sumproduct formula
=sumproduct((a4:a22=a1)*(a4:a22<a2))

--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
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

=sumproduct(--(a4:a22=a1),--(a4:a22<a2),--(D4:D22=1))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jrheinschm" wrote in message
...
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?

"jrheinschm" wrote:

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 ??

"Don Guillett" wrote:

glad it helped


--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
Don,
How very simple is my mind, or very complex is yours. You R the man!
It of
course does what I need, Thanks

"Don Guillett" wrote:

try a sumproduct formula
=sumproduct((a4:a22=a1)*(a4:a22<a2))

--
Don Guillett
SalesAid Software

"jrheinschm" wrote in
message
...
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