COUNTIFS with multiple inputs and dates

Btrombler

@heyjay That is the correct line of thinking! However, it is still saying unparseable :(

=COUNTIF(DISTINCT(COLLECT(Division:Division, [Submission Date]:[Submission Date], >DATE(2023, 3, 31), [Submission Date]:[Submission Date], <DATE(2024, 6, 31)))) + COUNT(DISTINCT(COLLECT([Please Specify:][Please Specify], [Submission Date]:[Submission Date], >DATE(2024, 3, 31), [Submission Date]: [Submission Date], <DATE(2024, 6, 31))))

when I tested it with just the first part of the formula, it says incorrect argument set

=COUNTIF(DISTINCT(COLLECT(Division:Division, [Submission Date]:[Submission Date], >DATE(2023, 3, 31), [Submission Date]:[Submission Date], <DATE(2024, 6, 31))))

Btrombler

@heyjay unfortunately it's still saying unparseable :(

heyjay

Use COUNT not COUNTIF.

=COUNT(DISTINCT(COLLECT(
Division:Division, 
[Submission Date]:[Submission Date], >DATE(2023, 3, 31), 
[Submission Date]:[Submission Date], <DATE(2024, 6, 31)))) + 

COUNT(DISTINCT(COLLECT(
[Please Specify:][Please Specify], 
[Submission Date]:[Submission Date], >DATE(2024, 3, 31), 
[Submission Date]: [Submission Date], <DATE(2024, 6, 31))))

=COUNT(DISTINCT(COLLECT(
Division:Division, 
[Submission Date]:[Submission Date], >DATE(2023, 3, 31), 
[Submission Date]:[Submission Date], <DATE(2024, 6, 31))))

Btrombler

@heyjay I tried that as well, with no luck

=COUNT(DISTINCT(COLLECT(Divsion:Division, [Submission Date]:[Submission Date] >DATE(2024, 3, 31), [Submission Date]:[Submission Date], <DATE(2024, 6, 31))))+ COUNT(DISTINCT(COLLECT([Please Specify]:[Please Specify], [Submission Date]:[Submission Date], >DATE(2024, 3, 31), [Submission Date]:[Submission Date], <DATE(2024, 6, 31))))

heyjay

You have a typo here. try to copy paste wha I posted previously.

Btrombler

@heyjay

Good catch, thank you! It's no longer imparseable, but it's not working correctly unfortunately, as the answer is returning "3" when it should be 12

heyjay

Must have something to do with your data/date. Please double check and adjust your formula as needed.