View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default min IF - Bob Philips follow up

=MAX(INDEX(('data FI'!$T$3:$T$10=W2)*('data FI'!$T$3:$T$10<=T2)*('data
FI'!$V$3:$V$10),0))

Is the formula that works for finding the max value between two dates...
change Max ti Min and I return 0. Any help is appreciated