T
Trevor Aiston
I have a data table on worksheet within a workbook which contains a mix of
numeric and text data.
eg a2:a92 containis numeric values of either 0 or 1 while each cell in
n2:n92 contains one of the following values
Clinical Psychologist
Consultant Clinical Psychologist
Consultant Psychiatrist
CPN
Health Care Assitant
Inpatient Nurse
Learning Disability Nurse
Occupational Therapist
Other
Other Doctor
Other qualified nurse
SHO
Social Worker/ASW
Team Leader
(blank)
I want to be able to sum A2:A92 based on a specific value in N2:N92.
Tried =SUMIF(epiexport!N2:N92,"Clinical Psychologist",A2:A92), but returns 0
rather than 1 which is the actual sum (calculated using subtotal on filtered
list).
ANy idea where I'm going wrong
TIA
Trev
numeric and text data.
eg a2:a92 containis numeric values of either 0 or 1 while each cell in
n2:n92 contains one of the following values
Clinical Psychologist
Consultant Clinical Psychologist
Consultant Psychiatrist
CPN
Health Care Assitant
Inpatient Nurse
Learning Disability Nurse
Occupational Therapist
Other
Other Doctor
Other qualified nurse
SHO
Social Worker/ASW
Team Leader
(blank)
I want to be able to sum A2:A92 based on a specific value in N2:N92.
Tried =SUMIF(epiexport!N2:N92,"Clinical Psychologist",A2:A92), but returns 0
rather than 1 which is the actual sum (calculated using subtotal on filtered
list).
ANy idea where I'm going wrong
TIA
Trev