View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jason
 
Posts: n/a
Default Skipping cells when using SUMPRODUCT function

I am trying to use the following function: SUMPRODUCT(--((E2:G2)E2)) to find
the number of positive changes in this series -- which works well. How would
I do this for JUST E2 and G2 rather than E2, F2, and G2?

Many thanks,

Jason