Get instant live Excel expert help to learn how to create a statistical function in Excel?

I need help in excel. How to make an average not show when all the numbers that would make that average are not entered yet.

Company A is considering launching a mobile streaming service for episodic television content. We would license the content for this streaming service on a quarterly basis for a flat fee per TV series. The service is free to customers, i.e. no subscription fee to access the content, and it generates revenue by displaying advertisements between episodes of each show. Advertisements are typically shown at the start of each episode, except for the first episode in each TV series. There are three types of TV content to consider: A, B, and C. We have included Q3 2017 data for each of the three types of content by TV episode, licensing fees by type of content, and average eCPMs received from our advertising partners. Key assumptions to augment your analysis can and should be sourced from any public resource available. You are the strategic finance analyst assigned to this initiative. Your responsibility is to provide a recommendation for how much to invest in new content and the allocation of your investment to each type of content over the next year. Please consider both quantitative and qualitative factors in your recommendation. You are expected to include KPIs and metrics in your analysis. Please perform your data analysis in Excel and include your scratch work. We will be evaluating the basis of your analysis as well as your final recommendation.

Need a formula that counts (1,2,3,4 ect..in cell M21) a range of cells, N4:N20, which are annual premium values. But I only want to add a sale count if the average monthly premium is above $30 per sale. So if someone has 4 sales but they don't equal a total of $120/mth ($30 x 4 = $120)... they would only get a count of 3 sales.

Need help putting together formula where it counts the number of sales but only if the average annual premium is above $360. So a sales = Sum(N:2:N:48)/360....but not greater than COUNTIF(N:2:N:48) ""

i have a sheet with info of two employees work. showing what job they are working on and the hours a PO has given. i have formulas already for taking the average of the hours and average hourly rate they are at but i need a formula to look at coulomb "A" and look for there name and use the formulas in K1,L1,M1,N1 to figure each individuals averages.

calculating average of different returns by different ticker symbols with one function.

I have a log that contains information for logistics I need to find a formula that will tell me the total ship days and the average ship days. Just now, because some cells are missing information, some cells state #value! and it wont calculate properly

I am looking to have a table populated with various information. The document has a log at the top and a table at the bottom. I need the bottom table to accurately tell me the total ship days for each shipment that has been shipped (marked with a tick) and also average days for each shipment marked with a tick. for those which are not marked with a tick I would like (N/A) populated In the box until the Shipped box is ticked. If the cell is populated with a 0 it will not give me accurate averages.

I need to do weighted averages for 3 sets of data. I was trying to do it under the data tab, subtotals (for example, "at each change in column A", but it will only do a straight average. Is there a way to do a weighted average based on a value in a 3rd column???

I am trying to excel count unique text that occurrences of a single text event before a unique text event for specific ID's. For example, ID1 has 5 events, the first 4 are Appeared and the final event is No Show. I am trying to find the average number of appearances before a no show for a large group.