asked on # 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

I have attached an example to sorta communicate the intent, but I know is not how you go about this request.

excel-example.xlsx

Microsoft Excel

please find attached

excel-example.xlsx

See attached

excel-example.xlsx

opppsss Sorry

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

William Peck

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?

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?

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)

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,

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?

Make sense?

Get an unlimited membership to EE for less than $4 a week.

Unlimited question asking, solutions, articles and more.

Log in or sign up to see answer

Become an EE member today7-DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform

or

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.

Not exactly the question you had in mind?

Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.

ask a question