IF functions based on conditional values
 

I'm having problems creating a formula for adding the values of cells in one
column based on the values in another column. It's currency based so I'm
trying to figure out how to add all the values in one column based on whether
a row in another column contains a certain currency, entered as text.

So far I'm coming up with a blank, can any gurus out there help me?

IF functions based on conditional values
 

I should add that I'm using Excel 2002.

Thanks

"mishmash" wrote:

I'm having problems creating a formula for adding the values of cells in one
column based on the values in another column. It's currency based so I'm
trying to figure out how to add all the values in one column based on whether
a row in another column contains a certain currency, entered as text.

So far I'm coming up with a blank, can any gurus out there help me?

IF functions based on conditional values
 

Try SUMIF:

=SUMIF(B:B,"Yes",A:A)

In this formula, your values to add are in column A and your criteria for
adding these values is in column B. The criteria to match in column B is
"Yes". Modify as needed.

HTH,
Paul

"mishmash" wrote in message
...
I'm having problems creating a formula for adding the values of cells in
one
column based on the values in another column. It's currency based so I'm
trying to figure out how to add all the values in one column based on
whether
a row in another column contains a certain currency, entered as text.

So far I'm coming up with a blank, can any gurus out there help me?