formula help again
I'm looking to count checked check boxes by the person who completed them based of a date previous month.
i have 6 check box columns labled CPT1 Approved, CPT2 Approved, CPT3 Approved, CPT4 Approved, CPT5 Approved, CPT6 Approved.
One column name CPT 1-6 completed by column
One Closed date column.
I'd like to count the checked boxes based of the person in the "CPT1-6 completed by" column for the previous month. I've been successful in getting the individual counts without the other columns for example counting check marks =(COUNTIFS([CPT1 Approved]:[CPT6 Approved], 1)). counting the number of times a name shows up =COUNTIFS([CPT 1-6 completed by]:[CPT 1-6 completed by], ="Christi Gray") but I can't figure out how to combine them to get me the count just for that person for the previous month. I have not tried any formula for the previous month yet because I can't get the above to work first. I'm doing this in a sheet summary.
I've tried several combinations of count/if/s, if and/or statements that I've found in the community but nothing seems to work please help.
Thank you in advance