Are you stuck on Excel or Google Sheets?

Hi i need a quick fix of my excel data showing corelation between two stock market fluctuations, the overall volem of the stock i need to buy needs to be takes form opening and closing the session not from the session average as sometimes the stock market drops at the 1 h of start of the session and the it peaks back and the moving average is not great function to calculate thestock price and the volume that the stock market is liste at the end of the session. so the goal is to make data more reliable upon the stock market at close so it actually can be more vialbe for further analysis. can u help me? need a stock market expert

Hi i need a quick fix of my excel data showing corelation between two stock market fluctuations, the overall volem of the stock i need to buy needs to be takes form opening and closing the session not from the session average as sometimes the stock market drops at the 1 h of start of the session and the it peaks back and the moving average is not great function to calculate thestock price and the volume that the stock market is liste at the end of the session. so the goal is to make data more reliable upon the stock market at close so it actually can be more vialbe for further analysis. can u help me? need a stock market expert

Hi, Hopefully someone will be able to help me. I'm wanting to calculate the average sum contained within a range of cells discarding blanks. The problem that I'm encountering is that there is an additional feature where I only want to take into consideration columns that contain specific text. =SUMIF(G79:HG79,"Sep-18",(G6:HG6/COUNTA(G6:HG6))) G79:HG79 will contain the specific text with G:HG containing the digits. Cheers all in advance

What is the formula to add 4 cell and add them together in another cell then in another call get the average of that cell

I need a formula that will take a row of data and calculate the monthly average increase or decrease. The row has months and then $ for each month.

I need help converting an array to an average number in a single cell before the formula auto creates the table. 2 columns 5 rows

I need an average of a non contiguous cells of times.

Compute the weighted average of students score from a spreadsheet using different weight for each category of marks

I need help calculating average time elapsed. It is in dd:hh:mm:ss text format and so I can't calculate using =AVERAGEIF

I have used the average button under the autosum drop down to get averages. Now I need to take those averages, and divide each number by 6, and make a new chart but I cannot copy paste the averages because they are formulas not numbers. I get #REF when i try to paste the averages in a new cell.