YTLE#91: PivotTable: Average w MONTH criteria

I am not sure which formula would be the easiest to calculate an average using month as one of the criteria. I tried to use averageifs but I cannot figure how to only pull values from a specified month

My database is something similar to

Date Classification Yield
Jan-20 Red 90
Jan-25 Blue 92
Feb-2 Green 88
Feb-13 Blue 93
Feb-21 Red 89
March-8 Blue 84
March-15 Green 86

I want to calculate an average yield for all "Red" for the Month of Jan what is the best way to go about this. I need very detailed instruction as I am not very good with excel. Is there a Mr Excel Youtube video that would help. I viewed YTLE 90 and I'm not that would work for me. Please Help!

Hello, I am hoping someone can help me;

I am doing my own accounts for my business and I'm trying to set up a system which on one sheet, shows the running total of takings so far in the year, my allowable expenses, the resulting taxable profit and then the goverment deductions (tax, NI and student loan). I'd then like to have another sheet of monthly summaries, detailing the same as the above but so I can take a wage and put some money away for the tax bill at the end of the year. I'm struggling to think of a formula which brings in the tax built up so far, minus what I've already put away from previous months to give that months contribution- I'm hoping this makes even the slightest bit of sense lol.

I've based my annual summary on the threshold I'm allowed before I start paying and I'm using an IF formula- if my taxable profits are less than 7500 (not right I know but for the example) then I pay no tax, if its more, I take 7500 from my profit and it gives me 20% of that.

I basically need to know how to average this figure over the 12 month summaries. I don't know if its possible or even if my question makes any sense, but hopefully someone can help me?!

I have a cell on a spreadsheet with =Today() calculation. This sheet also has a pivot table with another worksheet as it's source data. My pivot table has been grouped by month. I would like only the month that is relevant to the cell to show. All other months hidden. I've looked all through the site and tried different programming approaches, but none seem to work for this particular worksheet.

Hi team,

I have a spreadsheet that has columns of monthly values for three years of financial data and where the values for the latest month are added to the last column. Months that have not been completed will have a zero value (e.g. Jul-09).

Jan-09



Feb-09



Mar-09



Apr-09



May-09



Jun-09



Jul-09



Aug-09



Sep-09



1



2



3



4



5



6



0



0



0






I want to indicate a trend based on the last three months and I am using the formula below. The absolute references (e.g. $AP$1) are to cells containing these symbols ▼, ▲, ▬ to indicate that the latest month is trending up, down or staying the same compared to the average of the last three months.

=IF(AD11>(SUM(AB11:AD11)/3),$AP$1,IF(AD11

Hello!

Is it possible to display month using their "long" form instead of abbreviation? When I group data by month in a PivotTable, I only get "Jan", "Feb", etc. I would prefer "January", "February", etc. I know you can retype each month name but I wonder if there is some mysterious option hidden somewhere. Thanks!

I have a spreadsheet for daily sales. Details of each sale (including Date,
Order No, Product, Quantity, Unit Price, Discount, Total Price, etc) are
recorded on each row. The Date format is "dd/mm/yyyy (ddd)".

I would like to create a PivotTable to count the total sales of each product
for each month. However, I am having problem to do the count by month.
Currently, I have to add another Month column (and then hide the Month
column) in front of my Date column to indicate the month, and in order to do
the count by month in my PivotTable.

Is there a smarter way of doing the above?

Hi,

I've got a PivotTable report which is run on a monthly basis. The
source data is coped into the workbook and the data/charts refreshed.

The correct data (and date range) is being shown in the report, but the
date field on the X axis shows dates from both June and July as
selectable.

How can I prevent last month's dates being shown?

Thanks in advance for your help...

Best regards,

Kevin

Is there a way that I can calculate the weighted average in a PivotTable?

In my data, I have two columns:
Column A, which gives a dollar amount of an order.
Column B has 1, 0 or -1 in it, depending on what type of order it was.
For example, if it was an order that was placed, the data would say '1'.
If there were other line items for that same order (like S&H), to make sure that the order only counted once, the data would read '0'.
If the order was cancelled, the data would read '-1'.
In my pivot table, I want to provide an average order size based on the number of orders and dollars in total for the day.

If the data reads as noted below, I want to use the 'Average' option in the PivotTable Fields and drop it into the data part of the pivot table so that the average order size would be $1,525. When I tried it, the avg. was way off, so I'm not sure where the info is being pulled from.

COL A COL B
1,000 1
50 0
2,000 1

Thank you for your help.

I am trying to keep track of the average sales per day for each month. Since the current month is not yet over, dividing the month's total sales by 30 obviously does not tell me how many sales per day I am so far averaging. Is there a way to make Excel take account of the fact that the month is not over yet and thereby give an accurate calculation? For example, let's consider a month that only has 10 total days (for the sake of being concise)

# of sales per day:
1, 1, 3, 2, 4, 1, x, x, x, x

The letter x represents days which we have not yet reached in the month, and therefore should not be included in Excel's calculations. Can I somehow input a formula that, using the example data, will currently only divide the total sales by 6, but that will automatically divide the total by 7, 8, 9, and 10 as those days are reached? I imagine this would have something to do with Excel recognizing that there is no data in the cells for those final 4 days, and consequently knows to only divide the total by 6 at the moment.

Thanks for the help!