I have a table that I want to pull information per quarter ie Apr-Jun, Jul-Aug etc.
In cells A3:A20 I have used Q1, Q2, Q3, Q4 for the quarters.
In cell B3 I have created a list ‘All, Q1, Q2, Q3, Q4’, so I can select which quarter I want.
In cell B5 I have use the following formula to count:
=COUNTIF(A3:A20,B3) which works and provides me with one of the selected text from the list in B3, ie Q2. However, how do I get the formula to count all text A3:A20, if I select ‘All’ from the list at B3?
Can this be done?
Any help or advice is greatly appreciated.
Matt
In cells A3:A20 I have used Q1, Q2, Q3, Q4 for the quarters.
In cell B3 I have created a list ‘All, Q1, Q2, Q3, Q4’, so I can select which quarter I want.
In cell B5 I have use the following formula to count:
=COUNTIF(A3:A20,B3) which works and provides me with one of the selected text from the list in B3, ie Q2. However, how do I get the formula to count all text A3:A20, if I select ‘All’ from the list at B3?
Can this be done?
Any help or advice is greatly appreciated.
Matt