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 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.
> > > > >
> > > > >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks