Possible IF/AND question

Sharyn Kuppens

Hi team

I have 2 sheets - Detailed Monthly Inspection and Monthly Inspection Score.

I want the Monthly Inspection Score sheet to be able to look at the Detailed Monthly Inspection sheet and return the percentage for each store on a month by month basis, as the inspections are completed.

I think it might need to be an IF/AND equation but I keep getting an 'invalid operation' error. This is the equation I'm using and would like some help on:

=IF(AND({ClinicName} = "Botany Downs Clinic", {Month} = "May"), {Percentage})

If the clinic name is Botany Downs, and the month the inspection was completed is May, return the percentage score.

Any assistance would be appreciated.

Thanks, Sharyn

Dan W

If you are manually entering each month/name into the formula per cell you could do something simple like.

=SUMIFS({percentage column}, {Month column}, "may",{Name column}, "Botany Downs Clinic", )

Sharyn Kuppens

Thanks Dan but it's not working.

Dan W

@Sharyn Kuppens

If you would like to share a screenshot (with any sensitive data removed) of what you are working with we might be able to figure out what the issue is.