Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 6th 12, 03:42 AM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 4
Default 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?

  #2   Report Post  
Old July 6th 12, 09:36 AM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by pmterp View Post
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using the TODAY() function in a SUMIF function JPB Excel Worksheet Functions 4 July 27th 06 04:01 PM
SUMIF Function Inside SUMPRODUCT Function Abdul Waheed Excel Worksheet Functions 17 September 19th 05 04:24 PM
Can SUMIF function include AND function ShaneS Excel Worksheet Functions 1 May 17th 05 03:24 AM
How to nest a left function within a sumif function? LisaK Excel Worksheet Functions 1 February 23rd 05 01:50 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Excel Worksheet Functions 2 January 11th 05 11:01 PM


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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017