My database has a column for initial date from which Iidentify the YEAR and QUARTER. I use the COUNTIFS function where one criteriais QUARTER and the range is 3 for Q3. IfI want to look at the data for another QUARTER like Q1 to Q3, I have to changethe range to =<3. The report has over30 COUNTIFS lines so changing theformula from 3 to =<3 is a pain but doable. But for the other managers,they can’t make this change because the document is protected. How can I add adrop box, check box, etc so the managerscan select the QUARTER(S) and the COUNTIFS equations change accordingly?<o
></o
>