|
|
#10
10-16-2017, 10:12 AM
|
|||
|
|||
If start date is 1/1/17 formula is
=LARGE((SUMIF(OFFSET($B$2,0,ROW($1:$180)-ROW($1:$1),1,30),">0")/30),1) ARRAY formula is used To enter ARRAY formula Paste the formula Press F2 Press Ctrl+Shift+Enter keys together. formula will be covered with{} brackets by excel. 
|
|
|
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 |
Windows XP 
Office 2007
Threaded Mode