average progress depends on criteria and vlookup

Karmen P.
Karmen P. ✭✭
edited 08/15/22 in Formulas and Functions

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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!