Question on conditional formula.

[JRC]

Dear members:


I am trying to set up a spreadsheet with a conditional formula but
haven't yet found a way to create a conditional formula that works.

My spreadsheet has two columns set up side by side that contain (1) an
amount and (2) a text string (will probably be either a single letter
or a single word). A few cells will be created to display the sum of
all the values contained in the first column according to the criteria
set in the second column. Cells A, B and C will display the sum of
values contained in column 1 but each will only add the values that
meet their criteria - all values in column 1 associated with a string
in column 2 that equals "assets" will be added and the sum displayed
in cell A. Accordingly, all values in column 1 associated with a
string in column 2 that equals "consumables" will be added and the sum
displayed in cell B. Following the same principle all values in column
1 associated with a string in column 2 that equals "expenses" will be
added and the sum displayed in cell C.

How can I create a formula in Excel that allows me to sum values in a
column only if these values meet this criteria ? The formula in this
case would have to look at each individual value and either use it or
discard it and move on to the next until all values were evaluated and
the sum was produced and displayed.

Any ideas ???

Thank you in advance for your help.

Joseph Chamberlain

 

[JE McGimpsey]

Any ideas ???

Take a look at SUMIF() in XL Help.

 

[JRC]

Take a look at SUMIF() in XL Help.

Hi, JE.

The formula you suggested is perfect for what I need. I have tried it
and it works well.

Thank you for your reply and suggestion.

Joseph