average progress depends on criteria and vlookup

Karmen P.

Hello all,

we are trying the following:

In a new sheet we want to reproduce some information from the source file using the VLOOKUP function. So far so good.

Now the question is, if there is a formula,

which from the Children lines

outputs the average progress,

where the lead is called "Kunde".

There can be several lines with the lead "customer". In this example it is only one row.

I hope you can help me.

Find more posts tagged with

Formulas

Accepted answers

red1998

I think an index collect formula might work better

All comments

Ella

Are you able to use a report and filter by Lead instead of VLOOKUP?

Karmen P.

We use the VLOOKUP because we only want to look at certain entries in the new list.

Even if I would solve it via a report, I can unfortunately not show the progress per lead individually.

Maybe I try it rather with a SUMIF / COUNTIF formula in the source file and mirror only this number.

red1998

I think an index collect formula might work better

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.