Can I count in an array based on a function?

G

Guest

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:A4>0.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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting an Array based on a calculation 10
count based on single number 13
Count rows based on multiple criteria 3
Count nonblank cells based on another column 1
Countif Array 3
Counting number of rows based on mutiple criteria 2
How to count a coloum if two conditions are met 5
Using a function to count cells based on multiple criteria 1

Top