Conditional Sum Formula?

B

Boulder257

I have tried searching for an answer but have been unable to locate on
and to the best of my knowledge this cannot be done. But I thought
would check with the experts!

I want to create a conditional sum formula. For instance, let's say
have in Column A the amounts of different accounts. And, in column B
have whether I have reviewed that particular account (signified by a
or a N). Now, I want to be able to sum only those accounts that I hav
reviewed. Therefore, I need a conditional sum formula.

Currently I create a formula in Row C that reads =if(B1="Y",A1,0) an
then I total that column. However, I was hoping there was a way to d
this without creating another column and formula
 
R

Ron Rosenfeld

I have tried searching for an answer but have been unable to locate one
and to the best of my knowledge this cannot be done. But I thought I
would check with the experts!

I want to create a conditional sum formula. For instance, let's say I
have in Column A the amounts of different accounts. And, in column B I
have whether I have reviewed that particular account (signified by a Y
or a N). Now, I want to be able to sum only those accounts that I have
reviewed. Therefore, I need a conditional sum formula.

Currently I create a formula in Row C that reads =if(B1="Y",A1,0) and
then I total that column. However, I was hoping there was a way to do
this without creating another column and formula.
Click to expand...

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


--ron
 
Top