conditional formulas based on a time period
 

I need to be able to track data on a rolling 12 month cycle. For instance,
how much money has been brought in from exactly 1 year ago from todays date?,
Tomorrow, same question. My date is in Column B and the data that needs added
together is in Column G. If the date in Column B is within the last 364 days
from the current date I need the numbers in the corresponding Column G to add
together and give me a sum at a glance. Can anyone tell me if this is
possible and how to write the formula to get the info that I need?
Thanks

conditional formulas based on a time period
 

=SUMPRODUCT(--(B2:B200=TODAY()-364),--(B2:B200<=TODAY()),G2:G200)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Lisa" wrote in message
...
I need to be able to track data on a rolling 12 month cycle. For instance,
how much money has been brought in from exactly 1 year ago from todays
date?,
Tomorrow, same question. My date is in Column B and the data that needs
added
together is in Column G. If the date in Column B is within the last 364
days
from the current date I need the numbers in the corresponding Column G to
add
together and give me a sum at a glance. Can anyone tell me if this is
possible and how to write the formula to get the info that I need?
Thanks

conditional formulas based on a time period
 

Try this:

=SUMIF(B:B,"="&TODAY()-364,G:G)

Biff

"Lisa" wrote in message
...
I need to be able to track data on a rolling 12 month cycle. For instance,
how much money has been brought in from exactly 1 year ago from todays
date?,
Tomorrow, same question. My date is in Column B and the data that needs
added
together is in Column G. If the date in Column B is within the last 364
days
from the current date I need the numbers in the corresponding Column G to
add
together and give me a sum at a glance. Can anyone tell me if this is
possible and how to write the formula to get the info that I need?
Thanks

conditional formulas based on a time period
 

It works perfectly. Thank you!!

"Bob Phillips" wrote:

=SUMPRODUCT(--(B2:B200=TODAY()-364),--(B2:B200<=TODAY()),G2:G200)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Lisa" wrote in message
...
I need to be able to track data on a rolling 12 month cycle. For instance,
how much money has been brought in from exactly 1 year ago from todays
date?,
Tomorrow, same question. My date is in Column B and the data that needs
added
together is in Column G. If the date in Column B is within the last 364
days
from the current date I need the numbers in the corresponding Column G to
add
together and give me a sum at a glance. Can anyone tell me if this is
possible and how to write the formula to get the info that I need?
Thanks

conditional formulas based on a time period
 

This formula worked perfectly too. Thank You!!

"T. Valko" wrote:

Try this:

=SUMIF(B:B,"="&TODAY()-364,G:G)

Biff

"Lisa" wrote in message
...
I need to be able to track data on a rolling 12 month cycle. For instance,
how much money has been brought in from exactly 1 year ago from todays
date?,
Tomorrow, same question. My date is in Column B and the data that needs
added
together is in Column G. If the date in Column B is within the last 364
days
from the current date I need the numbers in the corresponding Column G to
add
together and give me a sum at a glance. Can anyone tell me if this is
possible and how to write the formula to get the info that I need?
Thanks

conditional formulas based on a time period
 

You're welcome!

Biff

"Lisa" wrote in message
...
This formula worked perfectly too. Thank You!!

"T. Valko" wrote:

Try this:

=SUMIF(B:B,"="&TODAY()-364,G:G)

Biff

"Lisa" wrote in message
...
I need to be able to track data on a rolling 12 month cycle. For
instance,
how much money has been brought in from exactly 1 year ago from todays
date?,
Tomorrow, same question. My date is in Column B and the data that needs
added
together is in Column G. If the date in Column B is within the last 364
days
from the current date I need the numbers in the corresponding Column G
to
add
together and give me a sum at a glance. Can anyone tell me if this is
possible and how to write the formula to get the info that I need?
Thanks