Forum Discussion
Solved
COUNTIFS returns either #VALUE or 0
Hello! I'm trying to count how many dates are in the red per "EVB'er". Red meaning the date is today or before today. Column C to J are formatted as dates. Let's call the table in my first scree...
- Sumproduct function will work for you.
You may write the formula as below.
=Sumproduct((Kalender!$C:$J<=TODAY())*(Kalender!$B:$B=[@Naam]))
Twifoounfortunately I do not see "browse" at the bottom of my post.
Let's call the table in my first screenshot, the one with the colours, Dates. Let's call the table in my second screenshot EVB.
I want to count every red cell (date is today or before today) in Dates!columns C through J (first screenshot) in every row where the value in Dates!column B (first screenshot) is the same as EVB!column A (second screenshot), for example "Clarissa Schneider". The result would be an integer and would be displayed in EVB!column B (second screenshot).
