I have been struggling with this for 2 weeks now and I am desperatly seeking
advice! How can I program a feature to pull information from the rest of the
workbook to go onto my summary sheet? Ex: How many recertifications are there
within 60 days of 1-6-06? That info would be on each page throughout the
workbook but I want it to scan through the dates and give me the total. Is
this possible? Can someone PLEASE help me before I pull of my hair out?!?!
Thank You so much
--
Bonnie Rone

Bonnie

I guess your question is really hard to answer without having an example
file showing what you you are talking about.. (or maybe its my blond
intelligence, for which I apologise... If you can send me an example file I
may be able to help you out.

--
Jeroen van Nieuwkerk




"BonnieRone" wrote:

I have been struggling with this for 2 weeks now and I am desperatly seeking
advice! How can I program a feature to pull information from the rest of the
workbook to go onto my summary sheet? Ex: How many recertifications are there
within 60 days of 1-6-06? That info would be on each page throughout the
workbook but I want it to scan through the dates and give me the total. Is
this possible? Can someone PLEASE help me before I pull of my hair out?!?!
Thank You so much
--
Bonnie Rone

Something like this maybe:

=SUMPRODUCT((Sheet1!A8:A15=TODAY())*(Sheet1!A8:A1 5<=(TODAY()+60))*(Sheet1!B8:B15="recertification") )
if you have a column that marks the dates as a recertification date.

or maybe just:

=SUMPRODUCT((Sheet1!A8:A15=TODAY())*(Sheet1!A8:A1 5<=(TODAY()+6)))
if the dates are all recertification dates in one column.

create 1 for every sheet then add them together or add the formulas end
to end but that might make for a very long formula.

Maybe someone else have a magic formula that will look thru all your
worksheet at the same time.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=498859

Pinmaster, I am working on that too, but I thank you so much for your help.
It's nice to know that there are places like this to help out people like me
who need it. Thanks again and have a great weekend!
--
Bonnie Rone



"pinmaster" wrote:


Something like this maybe:

=SUMPRODUCT((Sheet1!A8:A15=TODAY())*(Sheet1!A8:A1 5<=(TODAY()+60))*(Sheet1!B8:B15="recertification") )
if you have a column that marks the dates as a recertification date.

or maybe just:

=SUMPRODUCT((Sheet1!A8:A15=TODAY())*(Sheet1!A8:A1 5<=(TODAY()+6)))
if the dates are all recertification dates in one column.

create 1 for every sheet then add them together or add the formulas end
to end but that might make for a very long formula.

Maybe someone else have a magic formula that will look thru all your
worksheet at the same time.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=498859

Thanks Bonnie, I really think that SUMPRODUCT is the way to go in your
case but I have to admit "I'm not an expert" just trying to help. But
there are a lot of experts in this forum who can help pretty much
anybody. Very few posts ever goes unanswered here so if your have a
question to ask about excel this is definitely the place to come.

Cheers and good luck!
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=498859

Jeroen
Thank you so much for you attempt to help save me from going insane! This is
my 1st time using the microsoft website for help and I do not know how to
attach a file, to show you. Would you like me to email to you? I can try to
do an example on the site, but I am not sure that will work out so hot.
Thanks again, I look forward to hearing from you.
--
Bonnie Rone



"Jeroen" wrote:

Bonnie

I guess your question is really hard to answer without having an example
file showing what you you are talking about.. (or maybe its my blond
intelligence, for which I apologise... If you can send me an example file I
may be able to help you out.

--
Jeroen van Nieuwkerk




"BonnieRone" wrote:

I have been struggling with this for 2 weeks now and I am desperatly seeking
advice! How can I program a feature to pull information from the rest of the
workbook to go onto my summary sheet? Ex: How many recertifications are there
within 60 days of 1-6-06? That info would be on each page throughout the
workbook but I want it to scan through the dates and give me the total. Is
this possible? Can someone PLEASE help me before I pull of my hair out?!?!
Thank You so much
--
Bonnie Rone

You can probably do this with a SUMPRODUCT() function that includes
double unary operators, but that assumes your data is laid out in rows
with some kind of indicator of a recertification. Can you post a
sample of your data? Also, when you say "within 60 days" do you mean
before *and* after 1/6/06? And is 1/6/06 going to be a dynamic date
that changes every day, or every spreadsheet?

Thanks to everyone trying to help. I am going to try to post this as best as
possible, so please forgive me if it doesnt exactly come out right!

# of Bedrooms/# of people/Eff. Date/Annual Income/Max Income/Set
Aside/Tenant Pd Rent/Utility Allow./Subsidy Amt/Approved Rent/Tenant Pd
Less?/Max T.C. Rent/Tenant Pd Rent + UA/Less Than Max/Move Out Date?
Again, sry for the way this came out...these are all headers, along with
several others. This is the 2nd part of questions. The "Effective Date"
would be the date of the last recertification. SO, if I wanted a summary
sheet to pull specifics like, "How many "Move Outs" within 60 days of today's
date or how many "4 bedrooms at 50%", how would I be able to program the
summary sheet to do this? I know it almost seems impossible to do. Thanks
again for everyone's assistance in this...it is greatly appreciated!

--
Bonnie Rone



"Dave O" wrote:

You can probably do this with a SUMPRODUCT() function that includes
double unary operators, but that assumes your data is laid out in rows
with some kind of indicator of a recertification. Can you post a
sample of your data? Also, when you say "within 60 days" do you mean
before *and* after 1/6/06? And is 1/6/06 going to be a dynamic date
that changes every day, or every spreadsheet?