Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Calculations???????
Ok, here is the deal. I have 3 columns. In the first column I have description. In middle column i have charges for items in the other column i have type of item. Description ------ Price --- Type Summary ---------$12.00 -- S Carbon Copies --- $5.00 --- J Diskettes ---------$10.00 -- S Pens----------------$4.00 --- S Table of Contents--$2.00 --- J Mathematics C --- $24.00---- J Everything with a J needs to be added together and everything with an S need to be added together. SumIf doesn't seem to be the solution unless I simply don't know what I'm doing--which is likely. How can i do this? thanks! -- maurices5000 ------------------------------------------------------------------------ maurices5000's Profile: http://www.excelforum.com/member.php...fo&userid=5229 View this thread: http://www.excelforum.com/showthread...hreadid=540033 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Calculations???????
SUMIF should work - try this:
=SUMIF(C$2:C$100,"S",B$2:B$100), and =SUMIF(C$2:C$100,"J",B$2:B$100) These assume items to row 100 - adjust as necessary. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Calculations???????
you could try an array formula
=SUM((C2:C7="S")* B2:B7) you need to enter this by CTRL+SHIFT+ENTER "maurices5000" wrote in message news:maurices5000.27icry_1147123804.1631@excelforu m-nospam.com... Ok, here is the deal. I have 3 columns. In the first column I have description. In middle column i have charges for items in the other column i have type of item. Description ------ Price --- Type Summary ---------$12.00 -- S Carbon Copies --- $5.00 --- J Diskettes ---------$10.00 -- S Pens----------------$4.00 --- S Table of Contents--$2.00 --- J Mathematics C --- $24.00---- J Everything with a J needs to be added together and everything with an S need to be added together. SumIf doesn't seem to be the solution unless I simply don't know what I'm doing--which is likely. How can i do this? thanks! -- maurices5000 ------------------------------------------------------------------------ maurices5000's Profile: http://www.excelforum.com/member.php...fo&userid=5229 View this thread: http://www.excelforum.com/showthread...hreadid=540033 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Calculations???????
Great! Thanks Guys! That helped! -- maurices5000 ------------------------------------------------------------------------ maurices5000's Profile: http://www.excelforum.com/member.php...fo&userid=5229 View this thread: http://www.excelforum.com/showthread...hreadid=540033 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Format Not Working | Excel Discussion (Misc queries) | |||
Conditional formula - language needed | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |