View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vrk1 vrk1 is offline
external usenet poster
 
Posts: 25
Default Problem adding a range in Sumif function.

When I execute the formula,

{=SUMIF(Goal!A:A, $B$3 Goal!$H:$J)}

I am expecting this function to sum the Range Hx:Jy
where x is the starting value where B3 is found in A:A and y is the end value.

Instead, what I am seeing is this only sums Column H and not Column I and
Column J.

How do I solve this problem?