I have a worksheet that contains a date range in column B, and a reason code
(text) in column E. I am trying to count the number of times a reson code is
used for each date. I.E on 1/30/09 how many cells in column E contain reason
"XYZ". Each day a file is created with these exact column headings. The name
of the files is always that days date (Pulled file today so the name of the
file would be todays date). I want to be able to enter a formula in a
seperate workbook that will give me these counts for each days file by
changing the name of the file it references. I hope someone understands this
and can help me, cuz I have spent days messing with array formulas, COUNTIF,
COUNT IF, SUM IF, SUMIF and none of them will work, they all give me the
counts of both that meet the date and the reason code together. That is not
what I am trying to accomplish. SOMONE PLEASE HELP ME!!! THANK YOU IN
ADVANCE!!!!

This formula will count all the XYZ in column E of a file called
"01-30-2009"...edit as needed:

=COUNTIF([01-30-2009.xls]Sheet1!$E$2:$E$100,"XYZ")

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"MANYHEADACHES" wrote:

I have a worksheet that contains a date range in column B, and a reason code
(text) in column E. I am trying to count the number of times a reson code is
used for each date. I.E on 1/30/09 how many cells in column E contain reason
"XYZ". Each day a file is created with these exact column headings. The name
of the files is always that days date (Pulled file today so the name of the
file would be todays date). I want to be able to enter a formula in a
seperate workbook that will give me these counts for each days file by
changing the name of the file it references. I hope someone understands this
and can help me, cuz I have spent days messing with array formulas, COUNTIF,
COUNT IF, SUM IF, SUMIF and none of them will work, they all give me the
counts of both that meet the date and the reason code together. That is not
what I am trying to accomplish. SOMONE PLEASE HELP ME!!! THANK YOU IN
ADVANCE!!!!

Please don't repost the same question.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"MANYHEADACHES" wrote:

I have a worksheet that contains a date range in column B, and a reason code
(text) in column E. I am trying to count the number of times a reson code is
used for each date. I.E on 1/30/09 how many cells in column E contain reason
"XYZ". Each day a file is created with these exact column headings. The name
of the files is always that days date (Pulled file today so the name of the
file would be todays date). I want to be able to enter a formula in a
seperate workbook that will give me these counts for each days file by
changing the name of the file it references. I hope someone understands this
and can help me, cuz I have spent days messing with array formulas, COUNTIF,
COUNT IF, SUM IF, SUMIF and none of them will work, they all give me the
counts of both that meet the date and the reason code together. That is not
what I am trying to accomplish. SOMONE PLEASE HELP ME!!! THANK YOU IN
ADVANCE!!!!