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.
So Lhynne's total amount is (30+2) + 40 + (20 + 2).
I got the answer using the array formula found on this.
=SUMIF(A:A, "Lhynne",B:B) + (SUM((A:A="Lhynne")*(B:B<="30"))*2)
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments