How do I calculate a daily average in Excel? > updated?

Question

I guess my question was not clear enough... I need to find a daily average, so, for example:

Date|Amount
10/08/06|10
10/08/06|20
11/08/06|100
11/08/06|200
12/08/06|30


Manually, the total for the 10th is 30, the total for the 11th is 300, and the total for the 12th is 30, therefore the average is 120... but how do I calculate this as a function in Excel?

Answer 1

Divide the entries into separate columns: 1 column for each day, and allow a number of lines for different entries for any one day (for instance your example shows 2 entries of 11/08/06, so you'll need at least 2 lines for every day if you want to be consistent).

Between the "day" columns, have one column that has the "AVERAGE" formula in it, to calculate the average for that particular day. For example, next to the column for Friday 11/08/06, have a daily average column that refers to all the entries for that day. To enter an "AVERAGE" formula, click on the function icon next to the cell entry window just above the table display (the icon looks like "fx"), select AVERAGE and highlight the cells from which the entries to be averaged are. Copy the formula for every "daily average" column in the week.

At the end of the set of "daily average" columns, you may want to have a weekly average count. Simply create a column after the last daily average column for that week, use the AVERAGE formula tool and press control while selecting the daily average entries in that week. And voila! You have a weekly average.

It may be useful to design this spreadsheet on a weekly basis, and then just copy down the whole thing for the following week. At the end of it, you may even want to have a monthly average.

Answer 2

1

Answer 3

To work out an average, it is easier if the dates only have one number beside them for example 10/08/06 is 30. You could type this in the column beside your data. After you have entered the numbers as 30, 300, 30 you will need to enter the formula =AVERAGE (cell number:Cell number) putting the cell reference for the 10/08/06 in the first space and then the cell reference for the 12/08/06 in the 2nd space after the :
Hope this helps

Answer 4

Excel Daily Average

Answer 5

Highlight all of the data (including the headings), click on Data/PivotChart and PivotTable. When the window opens up, just click on next/ok to skip through the options as the default will be fine. When you return to the worksheet, you will have a new sheet with a blank box, and a small box with your headings in it.

Now drag the word date from the little box to the left hand vertical column in the big box and drag the word amount into the big main box.

This has now given you a list of dates down the side and the total amounts for each date next to it.

You can now just do a simple average function at the bottom of this list.

Answer 6

Binary options let users trade in currency pairs and stocks for various predetermined time-periods, minimal of which is 30 seconds. Executing trades is straightforward. The system uses user-friendly interfaces, which even an 8 years old kid, can operate without having to read any instructions. But winning trades is Not easy.
Binary trading is advertised as the only genuine system that lets users earn preposterous amounts of money in ridiculously short period of time. Advertisers try to implicate as if you can make $350 every 60 seconds; if it was true then binary trading would truly be an astonishing business.
However, does it make any sense? Can every trader make tons of money in binary trading? Who is actually paying all the money or the profit to traders?
The first challenge is finding a trustworthy binary broker; secondly, you need to find a binary trading strategy, which you can use to make profits consistently. Without an effective trading strategy, there is no way you can make money in this business.
Learning a profitable trading strategy is possible, You should watch this presentation video https://tr.im/16635
It's probably the best way to learn how to win with binary option

Answer 7

If you make informed decisions and approach your penny stock investments with the same thoroughness that you’d use in your other investments, you too can unlock a whole lot of profit potential. Learn here https://tr.im/rTvCM

It’s absolutely true that penny stock investors can make very quick gains. Synutra International, Inc. (NASDAQ: SYUT) is a great example of a penny stock. This dairy-based, nutritional-products company has jumped from a little Bulletin Board operation to a billion dollar corporation. The company finally graduated from Over-the-Counter status to the NASDAQ Stock Market bringing with it 113% gains in less than two months.

This happens all the time and it’s how some of the best investors in the world became the richest investors in the world. Buying some shares for pennies on the dollar and selling at $10 or $20 is possibly the fastest way from being a hobby investor to a super investor

Answer 8

David, I assume you only want the daily average to appear at the point when the date changes. So here's what I did:

Column A:

Date
08Oct2006
08Oct2006
08Oct2006
08Oct2006
08Oct2006
08Oct2006
08Oct2006
08Oct2006
08Nov2006
08Nov2006
08Nov2006
08Nov2006
08Nov2006
08Nov2006
08Nov2006
08Nov2006
08Dec2006
08Dec2006
08Dec2006
08Dec2006


Column B

Amount
10
20
10
20
10
20
10
20
100
200
100
200
100
200
100
200
30
30
30
30


Column C

Daily Average
Cell C2 has this formula:
=IF(AND (A2=A1, A2<>A3), SUMIF(A:A, A2, B:B) /COUNTIF(A:A, A2), "")

Simply copy down formula and then the average will appear only at the points where date changes. PREQUISITE: Data sorted by date in ascending order.

Happy averaging!

Regards,
QwertyKPH @ Yahoo

Answer 9

If you want to earn money with binary trading and you aren't a big expert you definitely need some kind of support. I use a software called "autobinary signals" and I earning good money with it. Here you can find all the details and also some video proofs: http://tradingsignal.toptips.org

Answer 10

A common misconception is that you will have to be a financial and business expert in order to successfully trade binary options. However, this is not true at all. Learn here https://tr.im/Hl2xm

Perhaps it’s true when it comes to traditional stocks trading but definitely not true in the case of binaries. You don’t have to be an expert to predict the movement of certain assets.