View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Thinking that indirect should work


What I want to do in the formula below is to have the $F$4 be variable going
from F4 to F369 (and yes $B$4 will have to changes as well)

=SUMPRODUCT($F$4:$F$370,--(MONTH($B$4:$B$370)=$O14))

Tried a couple of times and couldn't make it work- what do you recommend?
Thanks in advance