Hello all,
I currently have a formula in a sheet which scans a row of dates and then populates another cell with the number of occurrences within the month selected in nominated cell. The current formula is as follows :-
=SUMPRODUCT(--(TEXT(AB3:AW3,"mmm\\yy")=$AX$1),MOD(COLUMN(AB3:AW3)-COLUMN(AB3:AW3)+1,2))
What I now need to do elsewhere in the sheet is perform the same scan for a date but instead of returning the number of occurrences return a value held in another cell..
In addition to this I also need the ability not only to select an individual month currently held in $AX$1 (I simply select the month required from a drop down list) but to also have the ability to select a number of months i.e a business quarter or indeed YTD
Any Ideas?
Bookmarks