F
Fluke
Hi. I am building a report sheet that looks at other workbooks for
information and gives statistics. The other workbooks are exports from an
Oracle database.
In the exported sheets, I need to check that the first column = "IWS", the
second column - a date cell - is between two dates (normally the previous
month, and the third column says "Approved", and count the rows that fall
into this category.. There's other bits to take into account in the other
workbooks, like it being Complete rather than Approved, and if it's overdue
or due within 30 days of being requested, but if I can get this formula setup
correctly I can hopefully figure the rest.
Any help is very much appreciated. I don't mind if I need more than one
formula working on each other to give me the count as they can be on hidden
sheets in the Report worksheet and I can make a front sheet that has all the
count values.
information and gives statistics. The other workbooks are exports from an
Oracle database.
In the exported sheets, I need to check that the first column = "IWS", the
second column - a date cell - is between two dates (normally the previous
month, and the third column says "Approved", and count the rows that fall
into this category.. There's other bits to take into account in the other
workbooks, like it being Complete rather than Approved, and if it's overdue
or due within 30 days of being requested, but if I can get this formula setup
correctly I can hopefully figure the rest.
Any help is very much appreciated. I don't mind if I need more than one
formula working on each other to give me the count as they can be on hidden
sheets in the Report worksheet and I can make a front sheet that has all the
count values.