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?
example.
- Name | Amount
- Lhynne | 30
- Nica | 15
- Lhynne | 40
- Lhynne | 20
So Lhynne's total amount is (30+2) + 40 + (20 + 2).
Aucun commentaire:
Enregistrer un commentaire