Count distinct rows with multiple criteria

joslaz

Board Regular
Joined
May 24, 2018
Messages
75
Hello everyone!

I am struggling with a pretty simple problem at the moment.
I have the following two tables in the data model (power pivot)


tblGeneral
ID - Date - Value - Typ:


tblWO
ID - Date Start - Date Finished - Value - State - Typ

ID: ABC
Date: DD.MM.YYYY HH:MM:SS
Value: 250
Type: X or E
State: 00-99

Now I want to create a column in tblGeneral with the following criteria
Where
tblGeneral.Date = tblWO.Date Start
tblGeneral.Type = X
tblWO.State =>21


How can I manage that?
How would be the formular? I already started with COUNTX or COUNTAX... but it doesnt't work


Best Regards
Joshua
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Watch MrExcel Video

Forum statistics

Threads
1,099,600
Messages
5,469,628
Members
406,661
Latest member
west5405

This Week's Hot Topics

Top