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,
Try SUMIF:
www.officearticles.com/excel/...ft_excel.h tm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
quot;Bradley Bellquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I am fairly new to excel and have a problem that I have been trying to
gt; solve on my own for days without any luck. Any help will be greatly
gt; appreciated...
gt;
gt; I would like to extract values from a column (column D) in a spreadsheet
gt; where the text (column B) in a different column of the spreadsheet matches
gt; a certain criteria in the numerous rows and have the results of these
gt; values added up and the answer placed in a cell...
gt;
gt; Thank you kindly in advance,
gt;
gt; Bradley Bell,
gt;
gt;
gt;
Thanks Anne...
Looks like the just the thing I need... Gonna play around a bit..
Bradley Bell
Anne Troy wrote:
gt; Try SUMIF:
gt; www.officearticles.com/excel/...ft_excel.h tm
gt;
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;Bradley Bellquot; gt; wrote in message
gt; ...
gt;gt; Hi,
gt;gt;
gt;gt; I am fairly new to excel and have a problem that I have been trying to
gt;gt; solve on my own for days without any luck. Any help will be greatly
gt;gt; appreciated...
gt;gt;
gt;gt; I would like to extract values from a column (column D) in a spreadsheet
gt;gt; where the text (column B) in a different column of the spreadsheet matches
gt;gt; a certain criteria in the numerous rows and have the results of these
gt;gt; values added up and the answer placed in a cell...
gt;gt;
gt;gt; Thank you kindly in advance,
gt;gt;
gt;gt; Bradley Bell,
gt;gt;
gt;gt;
gt;gt;
gt;
gt;
- Jan 24 Wed 2007 20:35
Help Needed
close
全站熱搜
留言列表
發表留言