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!!!

 

Cheers,

 

Alex

By: Alex

Leave a Reply

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