laregest 30 consecutive average of values in a 180 cell range

		Microsoft Office Forums > Microsoft Excel > Excel
laregest 30 consecutive average of values in a 180 cell range

FAQ

Thread Tools

Display Modes

10-01-2017, 10:56 PM

xor

Windows 10 laregest 30 consecutive average of values in a 180 cell range

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

I am not sure, but you can try to take a look at row 14 in the attached file.

Cell B14 shows the average sales for first 30 days, cell C14 shows average sales for 02-jan-17 to 31-jan-17 and so on.

Attached Files

high average sales over large range_2.xlsx (16.5 KB, 11 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow	FUGMAN	Excel Programming	7	02-05-2017 08:37 AM
average formal if cell contains number and text	Michael Labuschagne	Excel	2	12-08-2016 06:35 AM
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM
Filling the consecutive cell by day.	aligahk06	Excel	1	09-15-2010 08:17 AM
calculate average depending on drop-down values	virencm	Word	0	08-06-2010 06:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:31 PM.