close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()