If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Counting cells between 2 values
Hi
If you like send me a sample of one of your workbooks with a detailed description what you want to achieve and maybe there is an easier solution. I'm still not sure, what kind of #weekly' report you want to create. Why do you want to access all worksheets within one workbook if each workbook represents only 1 day of your month Frank for some reason that add-in isn't working right, maybe i'm doing something wrong, I"ll give it a second looking over in a minute. In the meantime, is there anytype of VBA alternative to this? I mean, all it is that I'm trying to do is create weekly report. The workbook, is named after the month(Febuary) and each worksheet with the exception of the first and the last (named Top and Bottom) are days of the month (named 01, 02,... ...30, 31). Each worksheet has dates on them, always in the same column. I just want to know how many of the dates are between 2/2/04 and 2/5/04 on all of workbsheets between Top and Bottom. Surely there must be a way to do this. Or some type of alternative approach to getting my results. any help? It doesn't seem that complex, and yet it is... |
#12
|
|||
|
|||
Counting cells between 2 values
"abxy " wrote...
for some reason that add-in isn't working right, maybe i'm doing something wrong, I"ll give it a second looking over in a minute. I'll assume you mean the THREED function in MOREFUNC.XLL isn't working. It won't if you're tyring to pull data from closed workbooks. In the meantime, is there anytype of VBA alternative to this? FTHOI, I've put a Zip file containing some files with a minimal example of one approach on my ftp space. ftp://members.aol.com/hrlngrv/apull.zip There are two .XLS workbooks, a VBA source code (.BAS) file that needs to be imported into one of the two .XLS workbooks or into an open .XLA add-in, and a README file basically repeating this paragraph. It's slow, but it does get the job done. There's no other alternative of which I'm aware. I mean, all it is that I'm trying to do is create weekly report. The workbook, is named after the month(Febuary) and each worksheet with the exception of the first and the last (named Top and Bottom) are days of the month (named 01, 02,... ...30, 31). Each worksheet has dates on them, always in the same column. I just want to know how many of the dates are between 2/2/04 and 2/5/04 on all of workbsheets between Top and Bottom. Excel isn't too swift when it comes to 3D processing. With the exceptions of MODE and CONCATENATE, only the built-in worksheet functions that accept variable number of arguments also accept 3D references. No others do. Not SUMIF, not COUNTIF, not SUMPRODUCT. Also, 3D references can't be used as operands, so 'SheetX:SheetY'!A1:Z99+0 will only give you errors. That means that Excel provides *NO* built-in way for you to could the number of cells in a 3D reference meat *ANY* criteria. Not even if the 3D reference were in the same workbook as the cell formula referring to it. This is a major pain, but that's Excel for you. [Since I thoroughly enjoy pointing out how other spreadsheet can do things Excel can't, recent versions of 123 can handle this with @@ and @SUMIF.] Surely there must be a way to do this. Or some type of alternative approach to getting my results. any help? There is, but it takes programming. See above. It doesn't seem that complex, and yet it is... Yes. This *IS* Excel we're discussing. Until its 3D functionality is brought kicking & screaming into the 1990s(!), 3D blocks will continue to be a royal pain to process. |
|
Thread Tools | |
Display Modes | |
|
|