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]))
Sumproduct function will work for you.
You may write the formula as below.
=Sumproduct((Kalender!$C:$J<=TODAY())*(Kalender!$B:$B=[@Naam]))
You may write the formula as below.
=Sumproduct((Kalender!$C:$J<=TODAY())*(Kalender!$B:$B=[@Naam]))
Starrysky1988Thank you so much! That works perfectly!