Averaging Percentage of Completion

Please add your manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

Originally Posted by Kalan

So column M "MFG Stage" drop down data comes from that "Formula Data" tab. Column N "MFG %" data is a result from this formula "=IF(M4="Released",0%,IF(M4="Router",20%,IF(M4="Metal Fab",40%,IF(M4="Paint/ Vinyl",60%,IF(M4="FA",80%,IF(M4="Complete","100%",0))))))".

Everything should be pretty obvious when viewing the spreadsheet. I left most of the data in the spreadsheet so it would all make sense.

Hi,

I didn't ask you to repeat the formula I can see in the sheet. I asked you to state what results you expect and where. If everything was pretty obvious I wouldn't have asked

Remember that when you ask a question in a forum those of us who might be able to help know absolutely nothing about your system and work process or the terminology you use. Unless you have uploaded a workbook we know nothing about how it is laid out and little about what you want done with it or how the results should be presented.

Whilst these things are second nature to you since you live with the workbook all the working day we start with zero knowledge so you need to take us by the hand and explain in quite precise detail your aims and goals as well as stuff like how your data might look different in other situations.
Don't assume we are able to "figure it out". We're usually quite good but not psychic.

Put yourself in our position and think about whether what you've posted makes sense and is unambiguous to someone who's never seen it before.
You are asking us for help so help us to be able to help you by providing all the information we need, even if that information seems obvious or intuitive to you.

Neither do we need all your data. A representative subset is all that's necessary.

Perhaps in N4 copied to the other grey cells

=AVERAGEIFS($N4:$N$1000,$A4:$A$1000,A3,$L4:$L$1000,"<>No")

Would you upload an example please

I don't need hundreds of rows, just copy a couple of examples.

Cell N4:
While most of IF's returns real value in %, your last IF
.....IF(M4="Complete","100%",0)
returns 100% in text string. Change it to 100% (without double quote"") then it should works.