IF functions based on conditional values

M

mishmash

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?
 
P

PCLIVE

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
 
Top