SUMPRODUCT text/vs populated cells

Hi There,

I am trying to create a formula to count the amount of forms returned by a department.

The database is set up in a way as such:


Department                              Form Recieved?

HR                                           16/16/2014

IT                                            18/04/2014

Development                            14/04/2014


So Far i have the formula as below:

=SUMPRODUCT((‘HR Database’!C:C=”HR”)*????

but after the asterisk i am not sure how i can count the amount of times the date is displayed.

I feel like i have tried everything e.g. COUNTIFS and COUNTAs but to no avail.


Any help is much appreciated!!!





By: Alex

Leave a Reply

Your email address will not be published. Required fields are marked *