software

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 RoneBonnie

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

quot;BonnieRonequot; wrote:

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

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 quot;within 60 daysquot; 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?
Something like this maybe:

=SUMPRODUCT((Sheet1!A8:A15gt;=TODAY())*(Sheet1!A8:A1 5lt;=(TODAY() 60))*(Sheet1!B8:B15=quot;recertificationquot;) )
if you have a column that marks the dates as a recertification date.

or maybe just:

=SUMPRODUCT((Sheet1!A8:A15gt;=TODAY())*(Sheet1!A8:A1 5lt;=(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: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=498859Jeroen
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
quot;Jeroenquot; wrote:

gt; Bonnie
gt;
gt; I guess your question is really hard to answer without having an example
gt; file showing what you you are talking about.. (or maybe its my blond
gt; intelligence, for which I apologise... If you can send me an example file I
gt; may be able to help you out.
gt;
gt; --
gt; Jeroen van Nieuwkerk
gt;
gt;
gt;
gt;
gt; quot;BonnieRonequot; wrote:
gt;
gt; gt; I have been struggling with this for 2 weeks now and I am desperatly seeking
gt; gt; advice! How can I program a feature to pull information from the rest of the
gt; gt; workbook to go onto my summary sheet? Ex: How many recertifications are there
gt; gt; within 60 days of 1-6-06? That info would be on each page throughout the
gt; gt; workbook but I want it to scan through the dates and give me the total. Is
gt; gt; this possible? Can someone PLEASE help me before I pull of my hair out?!?!
gt; gt; Thank You so much
gt; gt; --
gt; gt; Bonnie Rone
gt; gt;

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
quot;pinmasterquot; wrote:

gt;
gt; Something like this maybe:
gt;
gt; =SUMPRODUCT((Sheet1!A8:A15gt;=TODAY())*(Sheet1!A8:A1 5lt;=(TODAY() 60))*(Sheet1!B8:B15=quot;recertificationquot;) )
gt; if you have a column that marks the dates as a recertification date.
gt;
gt; or maybe just:
gt;
gt; =SUMPRODUCT((Sheet1!A8:A15gt;=TODAY())*(Sheet1!A8:A1 5lt;=(TODAY() 6)))
gt; if the dates are all recertification dates in one column.
gt;
gt; create 1 for every sheet then add them together or add the formulas end
gt; to end but that might make for a very long formula.
gt;
gt; Maybe someone else have a magic formula that will look thru all your
gt; worksheet at the same time.
gt;
gt; HTH
gt; JG
gt;
gt;
gt; --
gt; pinmaster
gt; ------------------------------------------------------------------------
gt; pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
gt; View this thread: www.excelforum.com/showthread...hreadid=498859
gt;
gt;


Thanks Bonnie, I really think that SUMPRODUCT is the way to go in your
case but I have to admit quot;I'm not an expertquot; 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: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=498859Thanks 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 quot;Effective Datequot;
would be the date of the last recertification. SO, if I wanted a summary
sheet to pull specifics like, quot;How many quot;Move Outsquot; within 60 days of today's
date or how many quot;4 bedrooms at 50%quot;, 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
quot;Dave Oquot; wrote:

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