Possible IF/AND question

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

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.