Formula not giving me the right result

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.

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.
>
>

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.
> >
> >

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


"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.
> > >
> > >

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.
> > >
> > >

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

> 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.
> > > >
> > > >

You are most welcome.

"Steved" wrote:

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