Can I count in an array based on a function?
 

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

Take a look here

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--

Regards,

Peo Sjoblom

"HokieLawrence" wrote in 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

See your other post in .MISC

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

.