Count current year in worksheet

I am rather new to this forum, I have found it extremely useful and people are so helpful.
I have used the formula from "Count current year monthwise entries formula" thread http://www.excelforum.com/excel-form...s-formula.html and it works wonderfully.
My only problem is when there is text cells it will show #VALUE! as answer.
My formula is =SUMPRODUCT(--(YEAR(F15:F34)=YEAR(TODAY())))
I will be very grateful if someone can help, Thank you in advance

Regards
Alf

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Originally Posted by Vikas_Gautam

=SUMPRODUCT(--(iferror(YEAR(F15:F34)=YEAR(TODAY()),0)))

That needs to be array entered due to the IFERROR function.

Array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Try this...

Data Range

	F	G	H
15	9/1/2007	------	3
16	TEXT
17	10/31/2014
18	3/4/2013
19	11/28/2014
20	11/12/2005
21	6/10/2014
22	6/15/2003
23	8/4/2011
24	12/26/2007
25	11/17/2006

This formula entered in H15:

=SUMPRODUCT(--(TEXT(F15:F34,"yyyy")=YEAR(NOW())&""))

You're welcome. Thanks for the feedback!