software

Hi! I need some help!
Is there any way to write a formula that would look over an entire
spreadsheet and add values based on criteria in another column? example: I
have a spreadsheet with about 1000 rows amp; 5 columns. Of the 5 columns 2
would have the values I am looking for. example: Column B - row 2: $415,
row 3: $360, row 4: $500, Row 5: $750 etc. Column C - row 2: 5, row 3: 1,
row 4: 5, row 5 : 2 .. I would like the formula look over all the rows and
come back with something like =if (c2=5,b2) ... I would like it to add all
the values in column b that has critera in column c such as 5 ... this
example would come back with a total of $915 since both row 2 amp; row 4 have
values of 5 .... is this making any sense?
Thank you !
--
Jackie

your descrition of the criteria is pretty sketchy but you may have success
with sumif(),or combinations and subtotals of sumif()
--
paul
remove nospam for email addy!
quot;Jackiequot; wrote:

gt; Hi! I need some help!
gt; Is there any way to write a formula that would look over an entire
gt; spreadsheet and add values based on criteria in another column? example: I
gt; have a spreadsheet with about 1000 rows amp; 5 columns. Of the 5 columns 2
gt; would have the values I am looking for. example: Column B - row 2: $415,
gt; row 3: $360, row 4: $500, Row 5: $750 etc. Column C - row 2: 5, row 3: 1,
gt; row 4: 5, row 5 : 2 .. I would like the formula look over all the rows and
gt; come back with something like =if (c2=5,b2) ... I would like it to add all
gt; the values in column b that has critera in column c such as 5 ... this
gt; example would come back with a total of $915 since both row 2 amp; row 4 have
gt; values of 5 .... is this making any sense?
gt; Thank you !
gt; --
gt; Jackie

Could be soemthing like this:

your Byour Csearchsum
125,002188,00
15,0052189,00
72,00730,00
12,508416,00
16,0045112,00
45,00560,00
88,001772,00
52,0058102,50
64,00290,00
90,008

Formula in E2 and down: =SUMIF($C$2:$C$11;D2;$B$2:$B$11)

You may have to replace the semicolons with commas.

HansHi Jackie

One way
=SUMIF(C:C,5,B:B)
Change the 5 to any other criterion you require.

--
Regards

Roger Govierquot;Jackiequot; gt; wrote in message
...
gt; Hi! I need some help!
gt; Is there any way to write a formula that would look over an entire
gt; spreadsheet and add values based on criteria in another column?
gt; example: I
gt; have a spreadsheet with about 1000 rows amp; 5 columns. Of the 5 columns
gt; 2
gt; would have the values I am looking for. example: Column B - row 2:
gt; $415,
gt; row 3: $360, row 4: $500, Row 5: $750 etc. Column C - row 2: 5, row
gt; 3: 1,
gt; row 4: 5, row 5 : 2 .. I would like the formula look over all the rows
gt; and
gt; come back with something like =if (c2=5,b2) ... I would like it to add
gt; all
gt; the values in column b that has critera in column c such as 5 ... this
gt; example would come back with a total of $915 since both row 2 amp; row 4
gt; have
gt; values of 5 .... is this making any sense?
gt; Thank you !
gt; --
gt; Jackie