Avatar of Pete Edwards
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.
Microsoft Excel

Avatar of undefined
Last Comment
Professor J

8/22/2022 - Mon
Professor J

please find attached
Naresh Patel

See attached
Naresh Patel

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
Pete Edwards


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?
Professor J

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)
Pete Edwards

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?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Professor J

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
Sign up - Free for 7 days
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