Countifs multtiple tables

[Anonymous]

Hi,

I have 2 tables an in total 5 columns for the countifs function

Table 1                 Table 2 

Name                   Name

Date                     Date

Handled Mail       

I want to count the number of handled mails if there s a match between the name and date columns of both Tables

Kind regards,

[Anonymous]

Hi,

I have 2 tables and 5 columns for the COUNTIFS

Table Mail          Table Telephone

Name                 Name

Date                   Date

Handled Mail     

I want a column in Table Telephone with the handled mail if there is a match between the columns Name and Date of both tables.

kinds regards

[v-piga-msft · Accepted solution]

Hi @Anonymous,

You could create a relationship of the two tables and create a calculated column with IF FUNCTION.

Column =
IF (
    AND (
        'Table1'[Date] = RELATED ( 'Table2'[Date] ),
        'Table1'[Name] = RELATED ( 'Table2'[Name] )
    ),
    COUNT ( Table1[Handled Mail] ),
    BLANK ()
)

If you need additional help, please share your data sample and your desired output.

Best Regards,

Cherry