Hi - I'm new on the forum so pardon if this is a novice question - I'm wondering if there is a way to tweak the "if, then" statement in Excel to tell Excel to calculate the value in a corresponding column.
For instance, I would like to tell Excel: if a range of values in Column L = 1, then calculate the average for the corresponding range of values in Column G. Eventually, I would like to add more criteria to this statement, for instance: if a range of values in Column L = 1 and the corresponding range of values in Column H = 1, then calculate the average for the corresponding range of values in Column G.
Can somebody help me on this? Let me know if my question needs clarifying.
Thanks!
For instance, I would like to tell Excel: if a range of values in Column L = 1, then calculate the average for the corresponding range of values in Column G. Eventually, I would like to add more criteria to this statement, for instance: if a range of values in Column L = 1 and the corresponding range of values in Column H = 1, then calculate the average for the corresponding range of values in Column G.
Can somebody help me on this? Let me know if my question needs clarifying.
Thanks!