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

Your formula is correct except you wrote that columns A and N are on the same
worksheet, but you refer to diiferent ones. Omit epiexport! and try again with
=SUMIF(N2:N92,"Clinical Psychologist",A2:A92)

Regards,
Stefi

€žTrevor Aiston€� ezt Ã*rta:

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

Thanks stefi you made me realise my error. Infact the data is in a diffrent
worksheet, my error was not referencing the worksheet on the last part of the
formulae should have been
=SUMIF(epiexport!N2:N92,"Clinical Psychologist",epiexport!A2:A92)

Thanks again

"Stefi" wrote:

Your formula is correct except you wrote that columns A and N are on the same
worksheet, but you refer to diiferent ones. Omit epiexport! and try again with
=SUMIF(N2:N92,"Clinical Psychologist",A2:A92)

Regards,
Stefi

€žTrevor Aiston€� ezt Ã*rta:

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

You are welcome! Thanks for the feedback!
Stefi

€žTrevor Aiston€� ezt Ã*rta:

Thanks stefi you made me realise my error. Infact the data is in a diffrent
worksheet, my error was not referencing the worksheet on the last part of the
formulae should have been
=SUMIF(epiexport!N2:N92,"Clinical Psychologist",epiexport!A2:A92)

Thanks again

"Stefi" wrote:

Your formula is correct except you wrote that columns A and N are on the same
worksheet, but you refer to diiferent ones. Omit epiexport! and try again with
=SUMIF(N2:N92,"Clinical Psychologist",A2:A92)

Regards,
Stefi

€žTrevor Aiston€� ezt Ã*rta:

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