Sumifs or countifs and what is the formula

Eddie Endurium LLC

I have 3 columns of data:

• Column 1 is a location (for example 101, 102, 201, 202)
• Column 2 is a date (for example 12/1/2023, 12/2/2023)
• Column 3 is a duplicate transaction labeled as D or if not a duplicate it is blank

Based on the location of 101, I want to see how many transactions occurred on 12/1/2023, and are not a duplicate.

DKazatsky2

Hi @Eddie Endurium LLC,

Something like this should work for you.

=COUNTIFS(Column1:Column1,="101",Column2:Column2,=DATE(2023,12,1),Column3:Column3, = "")

Hope this helps,

Dave

Eddie Endurium LLC

Thank you!

DKazatsky2

Hi @Eddie Endurium LLC,

Something like this should work for you.

=COUNTIFS(Column1:Column1,="101",Column2:Column2,=DATE(2023,12,1),Column3:Column3, = "")

Hope this helps,

Dave

Eddie Endurium LLC

Thank you!