Count distinct rows with multiple criteria

joslaz

Board Regular
Joined
May 24, 2018
Messages
72
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

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,089,676
Messages
5,409,681
Members
403,276
Latest member
Oscar007

This Week's Hot Topics

Top