Get instant live Excel expert help with AVERAGE Function
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
What does =SUMIF($A$2:$A$88, "1015",$H$2:$H$88) mean?
Solved by E. F. in 26 mins
A. A single plot comparing the monthly mean air temperature and monthly total precipitation for 2012 for the two sites listed above. Include a descriptive caption below the figure. [Tips: Plot mean monthly air temperatures as line graphs and total monthly precipitation as column graphs; place total precipitation on a secondary axis; use colour to distinguish your data series]
Solved by D. H. in 16 mins
A single plot comparing the monthly mean air temperature and monthly total precipitation for 2012 for the two sites listed above. Include a descriptive caption below the figure. [******Plot mean monthly air temperatures as line graphs and total monthly precipitation as column graphs******}
Solved by Z. J. in 19 mins
I need a formulae to add totals having in one column and names in another columns but the thing is that i have to show it in dash board i mean in another sheet
Solved by A. A. in 28 mins
Trying to make sheet on retirement withdraws. Cell A would be Year, Cell B would be cash value C would be 3% withdraw (in dollars), D would be expected % gain on investment (I want to be able to change this as economy changes) I want to subtract C dollars from B for that total then I want sum of b - c then add the percentage of d for an estimate of how much I would have left. What I mean to be conservative I want to subtract my withdraw before I calculate the gain using gain percentage formula.
Solved by A. C. in 26 mins
what does this mean in optimization
=SUMPRODUCT(E$6:E$16,$K$6:$K$16)/E$21
Solved by A. L. in 19 mins
what does this mean....
=SUMIFS('Mach Orders'!$H:$H,'Mach Orders'!$L:$L,Summary!B25,'Mach Orders'!$F:$F,"Automatics")
Solved by D. D. in 16 mins
WHAT DOES A SQUARE SYMBOL WITH POINTS ON 2 CORNERS MEAN? AND HOW DO I GET RID OF IT?
Solved by D. L. in 20 mins
I have A's in column which mean Absent and I need a formula whereby I can add all the A in a different line
Solved by C. C. in 18 mins
I am having issues creating the one way data table to show the means and standard deviations when you change the proportion of portfolio 1. I have the mean formula and the standard deviation formula at the top and -1 through 1 down the left side. I highlight all of it and create a data table. I reference the "proportion of portfolio 1" cell in the column input box but when the data table comes out it has all the same numbers all they way down the table.
Solved by G. Q. in 30 mins