| 5279 |
2000-06-29 12:16:00 |
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. |
Guest (0) |