Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Conditional Formatting
2 views
Skip to first unread message
lcb4kc
Jan 20, 2010, 10:53:02 AM1/20/10
to
I have 2 spreadsheets (#1, #2) in a workbook. Speadsheet #1 has 2 columns
which are "dates of inquiries received (in cell A2:A129)" and the second is
"amounts worked on inquiry in minutes (B2:B129)". Spreadsheet #2 is a summary
of spreadsheet #1 and has rows in weekly increments and columns with the
headings of days of the week (Mon, Tues, Wed, Thurs, Fri) each with
subheading of "amounts of inquiries received ", "amount of minutes worked on
inquiry", "% of time spent on inquiry (based on a 2250 minute work day)" and
finally 2 more colums at the end summarizing the "total of weekly minutes
worked on inquiry" and "% of weekly minutes worked on inquiries (based on a
11250 minute work week)". With your help, I have the formula for spreadsheet
#2 "amount of inquiries received" =COUNTIF('Details
2008'!A:A,DATE(2008,1,9+(ROWS(F$3:F3)-1)*7). With this formula I was able to
do a fill down and get the count incrementally by week (FANTASTIC). Now I
need to find the formula to do the same for each daily subheading in
spreadsheet #2 and the final weekly count (last 2 columns of spreadsheet #2).
which are "dates of inquiries received (in cell A2:A129)" and the second is
"amounts worked on inquiry in minutes (B2:B129)". Spreadsheet #2 is a summary
of spreadsheet #1 and has rows in weekly increments and columns with the
headings of days of the week (Mon, Tues, Wed, Thurs, Fri) each with
subheading of "amounts of inquiries received ", "amount of minutes worked on
inquiry", "% of time spent on inquiry (based on a 2250 minute work day)" and
finally 2 more colums at the end summarizing the "total of weekly minutes
worked on inquiry" and "% of weekly minutes worked on inquiries (based on a
11250 minute work week)". With your help, I have the formula for spreadsheet
#2 "amount of inquiries received" =COUNTIF('Details
2008'!A:A,DATE(2008,1,9+(ROWS(F$3:F3)-1)*7). With this formula I was able to
do a fill down and get the count incrementally by week (FANTASTIC). Now I
need to find the formula to do the same for each daily subheading in
spreadsheet #2 and the final weekly count (last 2 columns of spreadsheet #2).
StephenB
Jan 20, 2010, 7:31:14 PM1/20/10
to
You are *way* off topic for this newsgroup.
Go here: http://social.answers.microsoft.com/Forums/en-US/category/officeexcel
Go here: http://social.answers.microsoft.com/Forums/en-US/category/officeexcel
-steve
lcb4kc <lcb...@discussions.microsoft.com> wrote:
--
Stephen Boots
MVP Windows Live
Windows Live OneCare/Live Mesh/MSE Forums Moderator
sbo...@mvps.org
0 new messages