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 & 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 & row 4 have
values of 5 .... is this making any sense?
Thank you !
--
Jackie