Count criteria multiple columns

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?

Probably and countifs or sumproduct should both work

The problem is likely to be in your data, perhaps dates are text, or "open" is "open " or errors in your source data etc but we can not see from your post

An attachment as per the yellow banner would help us solving your problem

Don't reference the entire column but the usage range only.
Either Excel is very slow or somewhere in the column, i.e. outside the subject data range, there may be numbers/text etc., which may throw SUMPRODUCT off.