Hi,

I am struggling to find the correct formula based on multiple columns.
Countifs does not work at all and cannot get a sumproduct to work.

What I am trying to do is count how many combinations exists for the below:

- Date in column K should be smaller then date in field A2
- Column J should be "open"
- F should be Petra


=SUMPRODUCT(--('Data. Projects'!K:K<=Datafields!A2);--('Data. Projects'!J:J="open");--('Data. Projects'!F:F="Petra"))

Any help?