ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Not Sure Which Function. Sumif, Maybe? (https://www.excelbanter.com/new-users-excel/446495-not-sure-function-sumif-maybe.html)

pmterp

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?

Spencer101

Quote:

Originally Posted by pmterp (Post 1603407)
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?

First recommendation would be to post an example workbook so we can see exactly what you're working with.


All times are GMT +1. The time now is 12:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com