formula request

I would like to learn how to write a formula whereas a column contains either "text", or "numeric" requirement, and when discovered within the column to take those lines and sum up another column applicable to that line.

I have attached an example to sorta communicate the intent, but I know is not how you go about this request.
excel-example.xlsx
Pete EdwardsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamCommented:
please find attached
excel-example.xlsx
0
Naresh PatelTraderCommented:
See attached
excel-example.xlsx
0
Naresh PatelTraderCommented:
opppsss Sorry
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Pete EdwardsAuthor Commented:
ProfessorJimJam,

On the "numeric" formula, what if I did not have the column to reference and just wanted to quickly scour over a data table that had the "6100" in the column, and return a "sum" in another column of that line when it found rows that had the "6100".

How would I write that formula?
0
ProfessorJimJamCommented:
in that case then use just like this   =SUMIF(B14:B30,6100,C14:C30)    see bold

that is your criteria, this works if your criteria range hold numeric , I mean real numeric, meaning the number is stored as number not as text.  and in any event if the number is stored as text in the criteria range then put that inside a double quote. like this   =SUMIF(B14:B30,"6100",C14:C30)
0
Pete EdwardsAuthor Commented:
yeah, but what if the data only "contains" a part of the cell field that has the 6100, and it also has other alfanumeric aspects in it, I still want to identify in the formula request to find any cell/field that "contains" 6100 regardless of the other additional info in that cell and sum another column.  This is really the  "key" of this experts request as I find to often my data table has this concept, and I want my formula to focus on the cell/fields that "contain" a certain aspect in that field, and when it finds my criteria match, add all the lines up of another column.

Make sense?
0
ProfessorJimJamCommented:
in that case regardless of the alphanumeric. the criteria of containing 6100

use like this  =SUMIF(B14:B30,"*6100*",C14:C30)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.