Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting an Array based on a calculation | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
Sum and Count Function | Excel Worksheet Functions | |||
count based on two fields - need quickly | Excel Worksheet Functions |