Formula not giving me the right result

[Steved]

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.

 

[JMB]

The ranges are not the same size. Typo?

 

[Steved]

Hello JMB from Steved

Papakura Depot appears from row 6 to row 2000 it is their 29 times in this
range in Column C

The objective is to look for Papakura Depot in Column C and sum the Column H.

Hopefully I've explained my issue.

Cheers.

 

[JMB]

Yes, but your formula as posted is searching C6:C2000, but is summing H2:H2000

 

[JMB]

Posted before finishing my thought,

with the range sizes mismatched, the numbers returned from column H will be
off by 4 rows

A match in C6 will return H2
A match in C50 will return H46

 

[Steved]

Thankyou.

You know I looked at it for about ten minutes and did not see what you have
seen.

Thankyou for taking timeout.

Cheers.

 

[JMB]

You are most welcome.

Thankyou.

You know I looked at it for about ten minutes and did not see what you have
seen.

Thankyou for taking timeout.

Cheers.