Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 10th 05, 11:09 AM
Jamesy
 
Posts: n/a
Default 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.

  #2   Report Post  
Old January 10th 05, 11:30 AM
JulieD
 
Posts: n/a
Default

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.



  #3   Report Post  
Old January 10th 05, 11:47 AM
Jamesy
 
Posts: n/a
Default

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.




  #4   Report Post  
Old January 10th 05, 03:03 PM
JulieD
 
Posts: n/a
Default

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.








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i get mutiple values using vlookup in excel, lookup value . Abhijeet Excel Discussion (Misc queries) 4 May 19th 05 04:30 AM
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 01:04 AM
LOOKUP FUNCTION WITH SUMS ABILITY Jamesy Excel Discussion (Misc queries) 1 January 10th 05 03:39 PM
Lookup Function Christopher Anderson Excel Discussion (Misc queries) 3 January 5th 05 03:38 PM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 01:00 AM


All times are GMT +1. The time now is 03:08 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017