LOOKUP FUNCTION WITH SUMS VALUES

Hello,

There might be a simple answer here but either way I need help, let me
explain my problem. For example "SHEET1" has granny smith apples in A1,
"SHEET2" has granny smith apples located in A:A (more than one entry) and
price per granny smith apple in B:B. So an example might be granny smith -
10p or on another row the granny smith apple might be 15p, now what I need
from sheet1 is the total value of granny smith apples. So I guess I require
a lookup function that sums values, is this process possible?

Any help or advice would be greatly appreciated.

Regards,
James.

Hi

you can use the SUMIF function
=SUMIF(Sheet2!A:A,"apples",Sheet2!B:B)

Cheers
JulieD

"Jamesy" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> There might be a simple answer here but either way I need help, let me
> explain my problem. For example "SHEET1" has granny smith apples in A1,
> "SHEET2" has granny smith apples located in A:A (more than one entry) and
> price per granny smith apple in B:B. So an example might be granny
> smith -
> 10p or on another row the granny smith apple might be 15p, now what I need
> from sheet1 is the total value of granny smith apples. So I guess I
> require
> a lookup function that sums values, is this process possible?
>
> Any help or advice would be greatly appreciated.
>
> Regards,
> James.

Thanks greatly!

Regards,
James.

"JulieD" wrote:

> Hi
>
> you can use the SUMIF function
> =SUMIF(Sheet2!A:A,"apples",Sheet2!B:B)
>
> Cheers
> JulieD
>
> "Jamesy" <[email protected]> wrote in message
> news:[email protected]...
> > Hello,
> >
> > There might be a simple answer here but either way I need help, let me
> > explain my problem. For example "SHEET1" has granny smith apples in A1,
> > "SHEET2" has granny smith apples located in A:A (more than one entry) and
> > price per granny smith apple in B:B. So an example might be granny
> > smith -
> > 10p or on another row the granny smith apple might be 15p, now what I need
> > from sheet1 is the total value of granny smith apples. So I guess I
> > require
> > a lookup function that sums values, is this process possible?
> >
> > Any help or advice would be greatly appreciated.
> >
> > Regards,
> > James.
>
>
>

you're welcome
"Jamesy" <[email protected]> wrote in message
news:[email protected]...
> Thanks greatly!
>
> Regards,
> James.
>
> "JulieD" wrote:
>
>> Hi
>>
>> you can use the SUMIF function
>> =SUMIF(Sheet2!A:A,"apples",Sheet2!B:B)
>>
>> Cheers
>> JulieD
>>
>> "Jamesy" <[email protected]> wrote in message
>> news:[email protected]...
>> > Hello,
>> >
>> > There might be a simple answer here but either way I need help, let me
>> > explain my problem. For example "SHEET1" has granny smith apples in
>> > A1,
>> > "SHEET2" has granny smith apples located in A:A (more than one entry)
>> > and
>> > price per granny smith apple in B:B. So an example might be granny
>> > smith -
>> > 10p or on another row the granny smith apple might be 15p, now what I
>> > need
>> > from sheet1 is the total value of granny smith apples. So I guess I
>> > require
>> > a lookup function that sums values, is this process possible?
>> >
>> > Any help or advice would be greatly appreciated.
>> >
>> > Regards,
>> > James.
>>
>>
>>