Formula to count multiple cell values and their dates

I am looking for assistance in creating a formula that will allow me to isolate values in the Provider/Resources cell, the Type cell and count based on Visit Date.

Below is the a snapshot of the sheet. As you can see, there are multiple names in the Provider/Resources column, as well as the Dept column. The first name in the Provider/Resources column matches the first entry in the Dept column and the second in both columns are related. I need assistance on a formula to capture and count for each name and type by the visits in a month/year.

Thank you in advance for your expertise!

Find more posts tagged with

Formulas

help

Accepted answers

All comments

bisaacs

Hey @Robert Scroggins,

I think it would make creating the formula (and your life easier) if you split out the Provider/Resources and the Dept Columns into at least 3 or 4 separate columns.

Also, can you clarify what you mean by the first name matches the first dept entry and the second in both columns are related? How do they match/how are they related?

Robert Scroggins

I am open for the best possible set-up. When the data is imported, it has the Provider/Resources and Dept. In this particular case, the 1st name in the provider/resources is the provider associated with the first dept link. In the below example, Vidal Jimenez, Natalie [966721] is associated with the DHC portion in DEPT and Foust, Christy [600084] is associated with LAN in DEPT.

I am looking for a formula that:

Counts the number of event types in a month/year
Attributes the provider with the dept

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.