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" wrote:

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" wrote:

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.