COUNTIFS not picking up some values - Name / Email

Krysten Green

I am trying to count the number of Submissions by Submitter. The Submitter uses a Form to enter a line on the Sheet. They identify themselves by email address on the Form. The COUNTIFS formula I'm using at first seemed to get hung up on whether the form displayed a name (for the contact) or the email address. I've updated all Submitter Fields to include a name on the contact, but I'm still getting inaccurate counts. What am I doing wrong?

=COUNTIFS({Communications}, =1, {Submission Date}, >=DATE(2023, 1, 1), {Submission Date}, <=DATE(2023, 12, 31), {Submitter}, Category@row)

The Category@row field is referencing the name of the Requestor.

heyjay

Your formula seems correct. Without seeing the complete table or providing more details about the error, it would be diffult to identify the problem.

KPH

I think the problem could be that you are trying to match a name (in category) to a contact (in submitter). Adding the name to the email address in submitter won’t make it match a name in category. Could you use email address for both?