#1   Report Post  
Posted to microsoft.public.excel.misc
Bradley Bell
 
Posts: n/a
Default Help Needed - Please

Hi,

I am fairly new to excel and have a problem that I have been trying to
solve on my own for days without any luck. Any help will be greatly
appreciated...

I would like to extract values from a column (column D) in a spreadsheet
where the text (column B) in a different column of the spreadsheet
matches a certain criteria in the numerous rows and have the results of
these values added up and the answer placed in a cell...

Thank you kindly in advance,

Bradley Bell,



  #2   Report Post  
Posted to microsoft.public.excel.misc
Anne Troy
 
Posts: n/a
Default Help Needed - Please

Try SUMIF:
http://www.officearticles.com/excel/...ft_excel.h tm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Bradley Bell" wrote in message
...
Hi,

I am fairly new to excel and have a problem that I have been trying to
solve on my own for days without any luck. Any help will be greatly
appreciated...

I would like to extract values from a column (column D) in a spreadsheet
where the text (column B) in a different column of the spreadsheet matches
a certain criteria in the numerous rows and have the results of these
values added up and the answer placed in a cell...

Thank you kindly in advance,

Bradley Bell,





  #3   Report Post  
Posted to microsoft.public.excel.misc
Bradley Bell
 
Posts: n/a
Default Help Needed - Please

Thanks Anne...

Looks like the just the thing I need... Gonna play around a bit..

Bradley Bell

Anne Troy wrote:
Try SUMIF:
http://www.officearticles.com/excel/...ft_excel.h tm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Bradley Bell" wrote in message
...
Hi,

I am fairly new to excel and have a problem that I have been trying to
solve on my own for days without any luck. Any help will be greatly
appreciated...

I would like to extract values from a column (column D) in a spreadsheet
where the text (column B) in a different column of the spreadsheet matches
a certain criteria in the numerous rows and have the results of these
values added up and the answer placed in a cell...

Thank you kindly in advance,

Bradley Bell,





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
VLOOKUP help needed! MartinC Excel Worksheet Functions 1 January 12th 06 12:46 PM
IF / Else Format help needed Paul B. Excel Worksheet Functions 5 January 5th 06 06:37 PM
solver related some financial knowledge may be needed Richard Payman Excel Discussion (Misc queries) 4 September 8th 05 02:37 PM
formula results take up to 2 lines if needed, but keep border smurf Excel Worksheet Functions 0 August 17th 05 08:55 PM
Custom percent format needed Will Fleenor Excel Worksheet Functions 1 June 29th 05 02:57 AM


All times are GMT +1. The time now is 06:44 AM.

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

About Us

"It's about Microsoft Excel"