Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Array Formula
Hi All,
I am trying to write an array formula that calculates the average of an array for a range of dates. I have the following spreadsheet set up: A B C D 1 Range Sep-06 Oct-06 2 Date Sep-06 Oct-06 Nov-06 3 Amount $500,000.00 $550,000.00 $600,000.00 I am using the following formula: {=AVERAGE(IF(AND((B2:D2)=$B$1,(B2:D2)<=$C$1),B3:D 3))} The problem is that the formula is returning $0.00. I have tried many variations of this but with no luck. Can anyone help me write an array formula that will calculate the average of the amount for the given range....i.e. for the range specified above the formula should return $$525,000. I hope I am making sense....please help. Brendan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
referencing the value of a cell containing an array formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |