View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sally Sally is offline
external usenet poster
 
Posts: 36
Default Sumproduct and Beyond

Hello
I am relatively new to VB and need help. I am not quite sure how to
accomplish this.... I need routine that will find the first blank cell in
Col H and insert a sumproduct type formula. That will sum all of the cells
in Col H where the value in the same row in col G is equal to "o" and the
value in col F contains "F". I also need to replicate this over 20 columns in
the same row. I am still trying to learn how to use sumproduct so if the
formula use would be different, what would this be?
Thanks