Pete Edwards

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

See attached

excel-example.xlsx

excel-example.xlsx

opppsss Sorry

ASKER

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,

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) see boldthat 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)ASKER

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?

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

excel-example.xlsx