Just to add, I'd like to sort the dates 2004.10.01 to 2004.10.31 whe doing the sum of dollar amount
A alexm999 Oct 26, 2004 #1 Just to add, I'd like to sort the dates 2004.10.01 to 2004.10.31 whe doing the sum of dollar amount
A Aladin Akyurek Oct 27, 2004 #2 alexm999 said: Just to add, I'd like to sort the dates 2004.10.01 to 2004.10.31 whe doing the sum of dollar amount. Click to expand... Assuming that dates are true dates... =SUMPRODUCT(--(CodeRange=101),--(AdvertisingRange="TV"),--(TEXT(DateRange,"yyyy.mm")=TEXT(X2,"yyyy.mm")),DollarRange) where X2 houses a true date, formatted as 2004.10.01 for cosmetics
alexm999 said: Just to add, I'd like to sort the dates 2004.10.01 to 2004.10.31 whe doing the sum of dollar amount. Click to expand... Assuming that dates are true dates... =SUMPRODUCT(--(CodeRange=101),--(AdvertisingRange="TV"),--(TEXT(DateRange,"yyyy.mm")=TEXT(X2,"yyyy.mm")),DollarRange) where X2 houses a true date, formatted as 2004.10.01 for cosmetics
