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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
Thanks greatly!

Regards,
James.

"JulieD" wrote:

Hi

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

Cheers
JulieD

"Jamesy" wrote in message
...
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.