| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Nice one Bob - thanks
"Bob Phillips" wrote: Assuming the values in B1:B31 =AVERAGE(IF(B1:B31<0,B1:B31)) which is an array formula, so commit with Ctrl-Shift-Enter. -- HTH RP (remove nothere from the email address if mailing direct) "Anthony" wrote in message ... Hi, can anybody advise of a formula to work out an average on a given number on the days passed in the month.....?? eg data below for first 5 days of month day1,20 day2,25 day3,32 day4,10 day5,9 so the average thus far in the month will be 19.2 (first 5days data divided by 5) if days 6 and 7 are added the formula would then work out the average for the first 7 days.....and so on hope thats clear thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
| AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Hybrid Mode
