I have a large array of data approximately 41 columns wide by about 180 rows
deep. The columns are headed by date information (weekly) and the rows are
resources.

I would like to count values in each row based on conditions of the columns.
Specifically, I'd like to count the number of resources in each week was
above a number that changes based on different criteria for each week.

Ultimately I manually entered in a different COUNTIF function for each week,
but is there a way that I can count based on some kind of function, for
example something along these lines: COUNTIF(A1:A4,A1:A40.9*A5)

Hope anyone knows what the heck I'm talking about and might be able to help
me out of this jam.

Thanks,
HokieLawrence

Hi!

As near as I can tell,

COUNTIF(A1:A4,A1:A40.9*A5)

translates to:

=SUMPRODUCT(--(A1:A4A5*0.9))

Biff

-----Original Message-----
I have a large array of data approximately 41 columns
wide by about 180 rows
deep. The columns are headed by date information
(weekly) and the rows are
resources.

I would like to count values in each row based on
conditions of the columns.
Specifically, I'd like to count the number of resources
in each week was
above a number that changes based on different criteria
for each week.

Ultimately I manually entered in a different COUNTIF
function for each week,
but is there a way that I can count based on some kind of
function, for
example something along these lines: COUNTIF
(A1:A4,A1:A40.9*A5)

Hope anyone knows what the heck I'm talking about and
might be able to help
me out of this jam.

Thanks,
HokieLawrence
.

Biff,

You're my hero. That works like a charm.

Now that I've got them counted, is there also a way to SUM those values if
they meet that same condition?

Also, can you explain how that works? I've never seen the (--( operation
and I'm not sure what it's making Excel do.

Thanks,
HokieLawrence



"Biff" wrote:

Hi!

As near as I can tell,

COUNTIF(A1:A4,A1:A40.9*A5)

translates to:

=SUMPRODUCT(--(A1:A4A5*0.9))

Biff

-----Original Message-----
I have a large array of data approximately 41 columns
wide by about 180 rows
deep. The columns are headed by date information
(weekly) and the rows are
resources.

I would like to count values in each row based on
conditions of the columns.
Specifically, I'd like to count the number of resources
in each week was
above a number that changes based on different criteria
for each week.

Ultimately I manually entered in a different COUNTIF
function for each week,
but is there a way that I can count based on some kind of
function, for
example something along these lines: COUNTIF
(A1:A4,A1:A40.9*A5)

Hope anyone knows what the heck I'm talking about and
might be able to help
me out of this jam.

Thanks,
HokieLawrence
.

J.E. McGimpsey explains it all at:
http://www.mcgimpsey.com/excel/doubleneg.html



HokieLawrence wrote:

Biff,

You're my hero. That works like a charm.

Now that I've got them counted, is there also a way to SUM those values if
they meet that same condition?

Also, can you explain how that works? I've never seen the (--( operation
and I'm not sure what it's making Excel do.

Thanks,
HokieLawrence

"Biff" wrote:

Hi!

As near as I can tell,

COUNTIF(A1:A4,A1:A40.9*A5)

translates to:

=SUMPRODUCT(--(A1:A4A5*0.9))

Biff

-----Original Message-----
I have a large array of data approximately 41 columns
wide by about 180 rows
deep. The columns are headed by date information
(weekly) and the rows are
resources.

I would like to count values in each row based on
conditions of the columns.
Specifically, I'd like to count the number of resources
in each week was
above a number that changes based on different criteria
for each week.

Ultimately I manually entered in a different COUNTIF
function for each week,
but is there a way that I can count based on some kind of
function, for
example something along these lines: COUNTIF
(A1:A4,A1:A40.9*A5)

Hope anyone knows what the heck I'm talking about and
might be able to help
me out of this jam.

Thanks,
HokieLawrence
.



--

Dave Peterson

Dave might have overlooked the first part of the question.

Try this:

=SUMPRODUCT(--(A1:A4A5*0.9),A1:A4)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Dave Peterson" wrote in message
...
J.E. McGimpsey explains it all at:
http://www.mcgimpsey.com/excel/doubleneg.html



HokieLawrence wrote:

Biff,

You're my hero. That works like a charm.

Now that I've got them counted, is there also a way to SUM those values
if
they meet that same condition?

Also, can you explain how that works? I've never seen the (--(
operation
and I'm not sure what it's making Excel do.

Thanks,
HokieLawrence

"Biff" wrote:

Hi!

As near as I can tell,

COUNTIF(A1:A4,A1:A40.9*A5)

translates to:

=SUMPRODUCT(--(A1:A4A5*0.9))

Biff

-----Original Message-----
I have a large array of data approximately 41 columns
wide by about 180 rows
deep. The columns are headed by date information
(weekly) and the rows are
resources.

I would like to count values in each row based on
conditions of the columns.
Specifically, I'd like to count the number of resources
in each week was
above a number that changes based on different criteria
for each week.

Ultimately I manually entered in a different COUNTIF
function for each week,
but is there a way that I can count based on some kind of
function, for
example something along these lines: COUNTIF
(A1:A4,A1:A40.9*A5)

Hope anyone knows what the heck I'm talking about and
might be able to help
me out of this jam.

Thanks,
HokieLawrence
.



--

Dave Peterson

Actually, I overlooked the complete thread save that last question.

Thanks for answering the real question.


Ragdyer wrote:

Dave might have overlooked the first part of the question.

Try this:

=SUMPRODUCT(--(A1:A4A5*0.9),A1:A4)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Dave Peterson" wrote in message
...
J.E. McGimpsey explains it all at:
http://www.mcgimpsey.com/excel/doubleneg.html



HokieLawrence wrote:

Biff,

You're my hero. That works like a charm.

Now that I've got them counted, is there also a way to SUM those values
if
they meet that same condition?

Also, can you explain how that works? I've never seen the (--(
operation
and I'm not sure what it's making Excel do.

Thanks,
HokieLawrence

"Biff" wrote:

Hi!

As near as I can tell,

COUNTIF(A1:A4,A1:A40.9*A5)

translates to:

=SUMPRODUCT(--(A1:A4A5*0.9))

Biff

-----Original Message-----
I have a large array of data approximately 41 columns
wide by about 180 rows
deep. The columns are headed by date information
(weekly) and the rows are
resources.

I would like to count values in each row based on
conditions of the columns.
Specifically, I'd like to count the number of resources
in each week was
above a number that changes based on different criteria
for each week.

Ultimately I manually entered in a different COUNTIF
function for each week,
but is there a way that I can count based on some kind of
function, for
example something along these lines: COUNTIF
(A1:A4,A1:A40.9*A5)

Hope anyone knows what the heck I'm talking about and
might be able to help
me out of this jam.

Thanks,
HokieLawrence
.



--

Dave Peterson

--

Dave Peterson