A
Art MacNeil
Hello Good Samaritans,
I have a spreadsheet which has a list of documents in it. Some are
classified as "Draft" and some are "Final". The classification is always
stored in Column B. I want to extract the number of "Draft" and "Final"
each week (ending on Friday) . The problem is COUNTIF doesn't do this
without a unique formula for each week. Is there another function that can
be used?
Here's a sample of my spreadsheet:
A1 S:/Tax1Volume/Forms_03/01_Sep_03
A2 Draft Doc A
A3 S:/Tax1Volume/Forms_03/02_Sep_10
A4 Draft Doc B
A5 S:/Tax1Volume/Forms_03/03_Sep_17
A6 Draft Doc C
A7 Draft Doc D
A8 S:/Tax1Volume/Forms_03/04_Sep_23
A9 Draft Doc E
A10 Draft Doc F
A11 Final Doc C
A12 Draft Doc G
A13 S:/Tax1Volume/Forms_03/05_Sep_27
A14 Draft Doc H
A15 Final Doc B
A16 S:/Tax1Volume/Forms_03/05_Sep_28
A17 Final Doc A
A18 Draft Doc I
A19 S:/Tax1Volume/Forms_03/07_Sep_30
A20 Final Doc G
I want to get a count of the Draft and Final forms for each week (ending on
Friday), the problem is the forms come in almost daily and they can be
either drafts or finals and there could be 1, or 2 or 625 of them. How do I
write this formula?
Thank you for your help,
Art.
I have a spreadsheet which has a list of documents in it. Some are
classified as "Draft" and some are "Final". The classification is always
stored in Column B. I want to extract the number of "Draft" and "Final"
each week (ending on Friday) . The problem is COUNTIF doesn't do this
without a unique formula for each week. Is there another function that can
be used?
Here's a sample of my spreadsheet:
A1 S:/Tax1Volume/Forms_03/01_Sep_03
A2 Draft Doc A
A3 S:/Tax1Volume/Forms_03/02_Sep_10
A4 Draft Doc B
A5 S:/Tax1Volume/Forms_03/03_Sep_17
A6 Draft Doc C
A7 Draft Doc D
A8 S:/Tax1Volume/Forms_03/04_Sep_23
A9 Draft Doc E
A10 Draft Doc F
A11 Final Doc C
A12 Draft Doc G
A13 S:/Tax1Volume/Forms_03/05_Sep_27
A14 Draft Doc H
A15 Final Doc B
A16 S:/Tax1Volume/Forms_03/05_Sep_28
A17 Final Doc A
A18 Draft Doc I
A19 S:/Tax1Volume/Forms_03/07_Sep_30
A20 Final Doc G
I want to get a count of the Draft and Final forms for each week (ending on
Friday), the problem is the forms come in almost daily and they can be
either drafts or finals and there could be 1, or 2 or 625 of them. How do I
write this formula?
Thank you for your help,
Art.