need advice on gathering data

**lostgrave2001** · 04-27-2012, 10:14 AM

helpfile1a.xlsx

Hello,
i am looking for some Help with this Spreadsheet i am creating please.

the Basic's is i have a sheet called "paperwork" and its a table with all the data at the moment and another called "yearly view by date", what i want this one to do is count how many times a Racf has appeared in the "paperwork" sheet and Ive managed this, but what i also need the "yearly view by date" sheet to do is count how many responses each Racf has provided as well.

i have no idea how to make this happen

???

So any help would be appreciated.
i have attached a copy for anyone would like to have ago.

Thank you

Kind Regards

Chris

(p.s i had to change the names on the sheets due to data protection)

**ChemistB** · 04-27-2012, 10:41 AM

=COUNTIFS(Paperwork!H:H,I6,Paperwork!L:L,">0")
Or (Excel 2003 compatable)
=SUMPRODUCT(--(Paperwork!H:H=I6),--(ISNUMBER(Paperwork!L:L)))
Either of these help?