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