samedi 21 mars 2015

How do you this in MS Excel?

I have two columns, Name (Column A) and Amount (Column B).


I was able to compute for the sum of amounts in B of a person who's name is "Lhynne" in column A, which can be done using this formula:



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


Now, I want to compute the total amount accounted for Lhynne and whenever the amount is less than or equal to 30, I'll add two to the amount. What formula can I use for this?


Thank you.


Aucun commentaire:

Enregistrer un commentaire