J
John
Hi All,
I have a problem below. Could somebody help, please. Thanks in advance.
Cust Amount
AA 5
AA 5
AA 5
AA 5
AA -5
AA -5
BB 7
BB 7
BB -7
AA - I want to be able to count if "AA" in range A2:A10 then count positive
amount minus negative amount in B2:B10. In this case, the answer is "2"
BB - The same thing with "BB". The answer is "1"
Thank you
John
I have a problem below. Could somebody help, please. Thanks in advance.
Cust Amount
AA 5
AA 5
AA 5
AA 5
AA -5
AA -5
BB 7
BB 7
BB -7
AA - I want to be able to count if "AA" in range A2:A10 then count positive
amount minus negative amount in B2:B10. In this case, the answer is "2"
BB - The same thing with "BB". The answer is "1"
Thank you
John