HELP!!! I have a formula that will tell me how many items are open with a
date in the past what I need now is one that will also tell me how many open
items will be coming up in the next two weeks and one for anything over two
weeks€¦. Any help would be greatly appreciated. Thanks in advance.

=SUMPRODUCT(--(F2:F13TODAY()),--(G2:G13="Open"))

I think your formula is incorrect. I believe it should be:
=SUMPRODUCT(--(F2:F13<TODAY()),--(G2:G13="Open"))
That would be for anything that is in the past. Yours was saying anything
greater than today.

The one from now though two weeks from now:
=SUMPRODUCT(--(F2:F13=TODAY()),--(F2:F13<=TODAY()+14),--(G2:G13="Open"))

And anything beyond that point:
=SUMPRODUCT(--(F2:F13TODAY()+14),--(G2:G13="Open"))

HTH,
Paul
--

"Lisa" wrote in message
...
HELP!!! I have a formula that will tell me how many items are open with a
date in the past what I need now is one that will also tell me how many
open
items will be coming up in the next two weeks and one for anything over
two
weeks.. Any help would be greatly appreciated. Thanks in advance.

=SUMPRODUCT(--(F2:F13TODAY()),--(G2:G13="Open"))

It worked Great Thanks!!!!!

Lisa

"PCLIVE" wrote:

I think your formula is incorrect. I believe it should be:
=SUMPRODUCT(--(F2:F13<TODAY()),--(G2:G13="Open"))
That would be for anything that is in the past. Yours was saying anything
greater than today.

The one from now though two weeks from now:
=SUMPRODUCT(--(F2:F13=TODAY()),--(F2:F13<=TODAY()+14),--(G2:G13="Open"))

And anything beyond that point:
=SUMPRODUCT(--(F2:F13TODAY()+14),--(G2:G13="Open"))

HTH,
Paul
--

"Lisa" wrote in message
...
HELP!!! I have a formula that will tell me how many items are open with a
date in the past what I need now is one that will also tell me how many
open
items will be coming up in the next two weeks and one for anything over
two
weeks.. Any help would be greatly appreciated. Thanks in advance.

=SUMPRODUCT(--(F2:F13TODAY()),--(G2:G13="Open"))

You're welcome.

--

"Lisa" wrote in message
...
It worked Great Thanks!!!!!

Lisa

"PCLIVE" wrote:

I think your formula is incorrect. I believe it should be:
=SUMPRODUCT(--(F2:F13<TODAY()),--(G2:G13="Open"))
That would be for anything that is in the past. Yours was saying
anything
greater than today.

The one from now though two weeks from now:
=SUMPRODUCT(--(F2:F13=TODAY()),--(F2:F13<=TODAY()+14),--(G2:G13="Open"))

And anything beyond that point:
=SUMPRODUCT(--(F2:F13TODAY()+14),--(G2:G13="Open"))

HTH,
Paul
--

"Lisa" wrote in message
...
HELP!!! I have a formula that will tell me how many items are open with
a
date in the past what I need now is one that will also tell me how many
open
items will be coming up in the next two weeks and one for anything over
two
weeks.. Any help would be greatly appreciated. Thanks in advance.

=SUMPRODUCT(--(F2:F13TODAY()),--(G2:G13="Open"))

Try these:

For the next 2 weeks from today:

=SUMPRODUCT(--(F2:F13=TODAY()),--(F2:F13<=TODAY()+14),--(G2:G13="Open"))

Greater than 2 weeks from today:

=SUMPRODUCT(--(F2:F13=TODAY()+14),--(G2:G13="Open"))

Or:

A1: =TODAY()

=SUMPRODUCT(--(F2:F13=A1),--(F2:F13<=A1+14),--(G2:G13="Open"))

=SUMPRODUCT(--(F2:F13=A1+14),--(G2:G13="Open"))


--
Biff
Microsoft Excel MVP


"Lisa" wrote in message
...
HELP!!! I have a formula that will tell me how many items are open with a
date in the past what I need now is one that will also tell me how many
open
items will be coming up in the next two weeks and one for anything over
two
weeks.. Any help would be greatly appreciated. Thanks in advance.

=SUMPRODUCT(--(F2:F13TODAY()),--(G2:G13="Open"))

As two weeks is 14 days, you can amend your formula like this:

=SUMPRODUCT(--(F2:F13TODAY()+14),--(G2:G13="Open"))

for anything over two weeks, and:

=SUMPRODUCT(--(F2:F13=TODAY()),--(F2:F13<=TODAY()+14),--
(G2:G13="Open"))

for anything between today and the next 2 weeks inclusive.

Hope this helps.

Pete

On Mar 7, 7:06 pm, Lisa wrote:
HELP!!! I have a formula that will tell me how many items are open with a
date in the past what I need now is one that will also tell me how many open
items will be coming up in the next two weeks and one for anything over two
weeks.... Any help would be greatly appreciated. Thanks in advance.

=SUMPRODUCT(--(F2:F13TODAY()),--(G2:G13="Open"))