sumif using today's date

I am trying to use SUMIF. In column A I have dates and column B there are
dollar values. I am trying to sum all dollar values due from today out to the
next 7 days. How do I add 2 criteria to the sumif formula?

2 ways

=SUMIF(A2:A30,">="&TODAY(),B2:B30)-SUMIF(A2:A30,">"&TODAY()+7,B2:B30)

format result as non date

or

=SUMPRODUCT(--(A2:A30>=TODAY()),--(A2:A30<=TODAY()+7),B2:B30)

--
Regards,

Peo Sjoblom

(No private emails please)


"Eqa" <Eqa@discussions.microsoft.com> wrote in message
news:28E32EE0-D75F-4B56-B808-B02072EFD378@microsoft.com...
>I am trying to use SUMIF. In column A I have dates and column B there are
> dollar values. I am trying to sum all dollar values due from today out to
> the
> next 7 days. How do I add 2 criteria to the sumif formula?

Hi!

Try one of these:

=SUMIF(A1:A13,">="&TODAY(),B1:B13)-SUMIF(A1:A13,">"&TODAY()+7,B1:B13)

=SUMPRODUCT(--(A1:A13>=TODAY()),--(A1:A13<=TODAY()+7),B1:B13)

You could even use a helper cell:

C1 =TODAY()

Then:

=SUMIF(A1:A13,">="&C1,B1:B13)-SUMIF(A1:A13,">"&C1+7,B1:B13)

=SUMPRODUCT(--(A1:A13>=C1),--(A1:A13<=C1+7),B1:B13)

Biff

"Eqa" <Eqa@discussions.microsoft.com> wrote in message
news:28E32EE0-D75F-4B56-B808-B02072EFD378@microsoft.com...
>I am trying to use SUMIF. In column A I have dates and column B there are
> dollar values. I am trying to sum all dollar values due from today out to
> the
> next 7 days. How do I add 2 criteria to the sumif formula?

Thanks That is great and NOW seems so easy.

"Peo Sjoblom" wrote:

> 2 ways
>
> =SUMIF(A2:A30,">="&TODAY(),B2:B30)-SUMIF(A2:A30,">"&TODAY()+7,B2:B30)
>
> format result as non date
>
> or
>
> =SUMPRODUCT(--(A2:A30>=TODAY()),--(A2:A30<=TODAY()+7),B2:B30)
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
>
> "Eqa" <Eqa@discussions.microsoft.com> wrote in message
> news:28E32EE0-D75F-4B56-B808-B02072EFD378@microsoft.com...
> >I am trying to use SUMIF. In column A I have dates and column B there are
> > dollar values. I am trying to sum all dollar values due from today out to
> > the
> > next 7 days. How do I add 2 criteria to the sumif formula?
>
>