Sum Numbers By Text

  • Thread starter Thread starter itsshahbaz
  • Start date Start date
I

itsshahbaz

Hello All,

I have an excel sheet that contains two columns. One is text ie. "Ne
Items" & "Old Items". The other column contains numbers. I am havin
a difficult finding the correct formula that will sum only "New Items"
Can someone please help me with this opportunity?

Best Regards,

Shahba
 
With Col A being your New/Old items and your values in Col B

=SUMIF(A1:A100,"New Items",B1:B100)
 
Shahbaz, here is one way, with New Items in A and numbers in B

=SUMIF(A1:A10,"New Items",B1:B10)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Back
Top