software

What formula do you use when there may not be a value there? Like:

ITEM QTY SOLD
T0887 50 1
T0887 100
T0887 200 2
T0992 50 3
T0992 100
To get:
# of sold items for each item?
--
Nicki Taylor

=SUMIF(A:A,quot;T0887quot;,C:C)

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;NTaylorquot; gt; wrote in message
...
gt; What formula do you use when there may not be a value there? Like:
gt;
gt; ITEM QTY SOLD
gt; T0887 50 1
gt; T0887 100
gt; T0887 200 2
gt; T0992 50 3
gt; T0992 100
gt;
gt;
gt;
gt; To get:
gt; # of sold items for each item?
gt; --
gt; Nicki Taylor
Thanks!
--
Nicki Taylorquot;NTaylorquot; wrote:

gt; What formula do you use when there may not be a value there? Like:
gt;
gt; ITEM QTY SOLD
gt; T0887 50 1
gt; T0887 100
gt; T0887 200 2
gt; T0992 50 3
gt; T0992 100
gt;
gt;
gt;
gt; To get:
gt; # of sold items for each item?
gt; --
gt; Nicki Taylor

Bob... I just wanted to say thanks b/c I have (obviously) not had much
experience in Excel and you got me off to a good start. There are so many
combinations which can be overwhelming, but thanks to nice folks like you my
confidence is building.
--
Nicki Taylorquot;Bob Phillipsquot; wrote:

gt; =SUMIF(A:A,quot;T0887quot;,C:C)
gt;
gt; --
gt;
gt; HTH
gt;
gt; RP
gt; (remove nothere from the email address if mailing direct)
gt;
gt;
gt; quot;NTaylorquot; gt; wrote in message
gt; ...
gt; gt; What formula do you use when there may not be a value there? Like:
gt; gt;
gt; gt; ITEM QTY SOLD
gt; gt; T0887 50 1
gt; gt; T0887 100
gt; gt; T0887 200 2
gt; gt; T0992 50 3
gt; gt; T0992 100
gt; gt;
gt; gt;
gt; gt;
gt; gt; To get:
gt; gt; # of sold items for each item?
gt; gt; --
gt; gt; Nicki Taylor
gt;
gt;
gt;