![]() |
Not Sure Which Function. Sumif, Maybe?
I'm not sure which function(s) to use to accomplish this.
Column A has a checkbox that indicates this line is included Column B has a checkbox that indicates a 50% discount of an amount Column C has the amount Say I have 3 lines of data I want to add the amounts in column 3 if the 1st box is checked but if the 2nd box is checked, I only want 50% of the amount added. Recommendations? |
Quote:
|
All times are GMT +1. The time now is 04:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com