LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
HokieLawrence
 
Posts: n/a
Default Counting an Array based on a calculation

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Array Formulas and ISNUMBER Henrik Excel Worksheet Functions 1 February 10th 05 12:31 AM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM
counting based on 2 conditions Thrava Excel Discussion (Misc queries) 3 December 8th 04 10:19 PM
Counting rows based on criteria in multiple cells Margaret Excel Discussion (Misc queries) 11 December 2nd 04 11:04 PM
Populating cells based on calculation Chris Excel Worksheet Functions 0 November 8th 04 01:22 PM


All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"