Hi Everyone. I am using a countIF that takes its reference from cell values I typed so that I can change the portion of the table that is searched.
=COUNTIF(INDIRECT($E$5):INDIRECT($E$7),H18)
Right now, I'm entering values of "G2" and "SH12" into the cells to narrow the countIF to the range of G2:SH12. I'm looking to make this a little more efficient as the Rows will always be 2 to 12. I want to only have to type "G" and "SH" or "J" and "X" to search G2:SH12 or J2:X12. I want to include the row reference in the formula. I guess I can't do:
=COUNTIF(INDIRECT($E$5) & "2" :INDIRECT($E$7) & "1",H18)
What can I do?
Thanks!
=COUNTIF(INDIRECT($E$5):INDIRECT($E$7),H18)
Right now, I'm entering values of "G2" and "SH12" into the cells to narrow the countIF to the range of G2:SH12. I'm looking to make this a little more efficient as the Rows will always be 2 to 12. I want to only have to type "G" and "SH" or "J" and "X" to search G2:SH12 or J2:X12. I want to include the row reference in the formula. I guess I can't do:
=COUNTIF(INDIRECT($E$5) & "2" :INDIRECT($E$7) & "1",H18)
What can I do?
Thanks!