Countif Formula based on Column
I am looking to find a formula that will count if it is a quarter column.
My sheet has columns - Fiscal Year, Quarter 2/3 (etc.) and then Monthly breakdowns.
FY1 Total | Q1 Total | Jan | Feb | Mar | Q2 Total | Apr | May ...
And continues on for a couple of FY.
I want to get a count of how many quarters have a value in it.
Our previous sheet did not need monthly columns, and had the quarters next to one another. Now we are migrating to add in monthly totals.
Is there a way to count if there is a value ONLY in the quarter column (it could span across greater than 9 quarters depending on the project)?
Thank you in advance!
Help Article Resources
Check out the Formula Handbook template!