fayez_MrExcel
Active Member
- Joined
- Oct 29, 2005
- Messages
- 439
- Office Version
- 365
- Platform
- Windows
I have a range of dates where i am counting the number cells where the year is equal to today's year.
=SUMPRODUCT(--(YEAR(A2:A24)=YEAR(TODAY())))
However, it returns #value! because there are many cells where the value is not a date e.g. the cell contains as "---" Or "Not applicable".
How can ignore the #value! in this case
=SUMPRODUCT(--(YEAR(A2:A24)=YEAR(TODAY())))
However, it returns #value! because there are many cells where the value is not a date e.g. the cell contains as "---" Or "Not applicable".
How can ignore the #value! in this case