View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMB
 
Posts: n/a
Default Formula not giving me the right result

The ranges are not the same size. Typo?


"Steved" wrote:

Hello from Steved

This formula give me the right result. SUM(H273:H312)

This formula give me a different answer.
SUMIF($C$6:$C$2000,"PAPAKURA DEPOT",H$2:H$2000)

How can I get the formula to give me the result.

Thankyou.