software

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---- JEverything 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: www.excelforum.com/member.php...foamp;userid=5229
View this thread: www.excelforum.com/showthread...hreadid=540033SUMIF should work - try this:

=SUMIF(C$2:C$100,quot;Squot;,B$2:B$100), and
=SUMIF(C$2:C$100,quot;Jquot;,B$2:B$100)

These assume items to row 100 - adjust as necessary.

Hope this helps.

Peteyou could try an array formula

=SUM((C2:C7=quot;Squot;)* B2:B7)

you need to enter this by CTRL SHIFT ENTER
quot;maurices5000quot; gt;
wrote in message
news:maurices5000.27icry_1147123804.1631@excelforu m-nospam.com...
gt;
gt; Ok, here is the deal. I have 3 columns. In the first column I have
gt; description. In middle column i have charges for items in the other
gt; column i have type of item.
gt;
gt; Description ------ Price --- Type
gt; Summary ---------$12.00 -- S
gt; Carbon Copies --- $5.00 --- J
gt; Diskettes ---------$10.00 -- S
gt; Pens----------------$4.00 --- S
gt; Table of Contents--$2.00 --- J
gt; Mathematics C --- $24.00---- J
gt;
gt;
gt; Everything with a J needs to be added together and everything with an S
gt; need to be added together. SumIf doesn't seem to be the solution unless
gt; I simply don't know what I'm doing--which is likely.
gt;
gt; How can i do this?
gt;
gt; thanks!
gt;
gt;
gt; --
gt; maurices5000
gt; ------------------------------------------------------------------------
gt; maurices5000's Profile:
www.excelforum.com/member.php...foamp;userid=5229
gt; View this thread: www.excelforum.com/showthread...hreadid=540033
gt;

Great! Thanks Guys! That helped!--
maurices5000
------------------------------------------------------------------------
maurices5000's Profile: www.excelforum.com/member.php...foamp;userid=5229
View this thread: www.excelforum.com/showthread...hreadid=540033