Help w/multiple column criteria summary report
Hi team - I've got a sheet with over 100 columns and only specific columns are "mandatory", indicated by an (M) at the end of the column title.
There are several more columns to the right of this graphic - some with a "mandatory" column and some without (meaning there is no "mandatory" helper column for the question for many of the other columns)
I'm trying to figure out the best way to create a summary report that:
- Counts the number of contracts CREATED in a specific month (for example, July), has the check mark in the "mandatory" (M) column and for those mandatory questions (column to the right of the (M) column) the answer is either "N/A" or "No - Fail"
Is there a way to specify then entire column range in a summary report and look for those other criterion to return a number of agreements created in July that have mandatory questions answered either "N/A" or "No - Fail" ?
Thanks for your help on this,
Help Article Resources
Check out the Formula Handbook template!