Home |
Search |
Today's Posts |
#1
|
|||
|
|||
AVERAGE problem
Okay, to start...I have 2 rows, 1 and 2, where Row1 has dd-"month" and Row2 has "day". And a 3rd row has percent values which are to be averaged. Example: D1=01-Apr--- E1=02-Apr D2=Fri---------E2=Sat D3=50%-------E3=100% and so on and so forth. We'll just say it goes until the end of the month and the following months thereafter. Now let's say that: D5=Apr-05-----E5='The average of the month EXCLUDING weekends and holidays'. D6=May-05-----E6='Same formula as E5 except using the month of May' and so on... How could I sum the values of the percentages given the criteria? I would guess it would be using the Index & Match functions, but how? -- malik641 ------------------------------------------------------------------------ malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190 View this thread: http://www.excelforum.com/showthread...hreadid=388046 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
plotted Average | Charts and Charting in Excel | |||
Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
What is this kind of average called? | Excel Worksheet Functions | |||
"Drop the lowest" in computing average | Excel Worksheet Functions | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions |