I'm sure this is simple, but being a complete newbie, I need a little formula help. I have inherited a workbook and need to chart three values from column I, where the values in Column C is <20. I've tried variations of COUNTIF and IF(COUNTIF, and can't work it out, and I'm hitting a deadline. Thanks in advance for any suggestions.
Mr. NewBee :wink:
More details: Basically I need three formulas, so I can chart this, one where column I value is 5, one where it is 4 and one where it is 3, and the values in column C are less than 20. Column C is numbers 0-100. Column C is only 3-5.
Mr. NewBee :wink:
More details: Basically I need three formulas, so I can chart this, one where column I value is 5, one where it is 4 and one where it is 3, and the values in column C are less than 20. Column C is numbers 0-100. Column C is only 3-5.