PDA

View Full Version : Excel - Conditional 'Count' and 'Sum'



29-06-2000, 11:16 PM
I have a need to produce a formula for conditional 'C****' and 'Sum' functions. I have 1000 rows of data. Column A is Integers between 5 & 15, Column B is Integers between 1 & 20, and Column C is $Values. I wish to be able, without sorting the Data (because I cannot then readily expand the data base), to count the number of, say, 5's in Column B when Column A is 9,and then Sum Column C for that selection if the $value in Column C lies between specific limits.
Would appreciate assistance.