Link to home
Start Free TrialLog in
Avatar of Bill Golden
Bill GoldenFlag for United States of America

asked on

I need to total a double column in Excel taking an alternate value if one exists

I have a workbook and need to total (Excel) Column Q, except using the alternate value on any line with an amount in (Excel) column R. In the attached sample, it would be 7,833 + 1,833 + 3,000 + 5,833 + 7,833 + 5,833 + 7,833 + 7,833 + 1,833 + 3,000...
ABC-Properties-Section-1245-Workshe.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bill Golden

ASKER

Excellent.  Thanks.