A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Counting cells between 2 values



 
 
Thread Tools Display Modes
  #11  
Old February 7th, 2004, 02:07 AM
Frank Kabel
external usenet poster
 
Posts: n/a
Default 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  
Old February 7th, 2004, 06:54 AM
Harlan Grove
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.