formulas when there may/may not be a value
 

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

formulas when there may/may not be a value
 

=SUMIF(A:A,"T0887",C:C)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"NTaylor" wrote in message
...
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

formulas when there may/may not be a value
 

Thanks!
--
Nicki Taylor


"NTaylor" wrote:

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

formulas when there may/may not be a value
 

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 Taylor


"Bob Phillips" wrote:

=SUMIF(A:A,"T0887",C:C)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"NTaylor" wrote in message
...
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