average ifs

Hi folks. About 3 weeks ago, I began to try and learn how to use power query, and while I think I'm slowly getting the basics, I cannot for the life of me figure out how to do what would be an insanely easy task in Excel. I have a fairly large database that I'm working with, and am trying to...

I am tracking compliance percentages (2 rows per calendar day). I want a rolled-up matrix of the averaged results for the previous month. I want the average part of the statement to ignore blanks and errors (not column item is required every day) but include zeros (indicates non-compliance). I...

I have to find average number of days if status = new or open,severity= 4,area=Apps Demo table Area Severity Status No of days Apps 4 new 20 Apps 3 open 10 Node 3 close...

Good afternoon, I am trying to see if it's possible to create an average/if type formula. Basically I have 2 columns of reference, E and J. E is the date closed and J is the date logged. I want to look and see the average amount of days open per month. For instance, If the date in column E...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

I need to average a list of numbers, excluding the number zero. Example list: 1, 0, 2, 2, 0, 5, 0. How can you average 1, 2, 2, 5 AND exclude the zeros from calculation? Thanks!

A B C 1BR Q2 $50 2BR Q2 $60 2BR Q4 $70 1BR Q1 $40 I need to get the average cost if it's a 1BR in Q2 Help please...