Hey guys,
I have a pretty large spreadsheet that shows manufacturing status for each sign at each location. I have a title row in bold and underneath are all of the signs with MFG (manufacturing) %.
I would like to average the the percentage of completion for each location on the title row and at the very bottom of the spreadsheet in the "summary" chart.
Every time that I try to do the "Averageif" formula, it does not calculate 100% correctly.
Any help is appreciated!
(This is my first post and I am not sure if my Spreadsheet attached properly)
Bookmarks