Solved

formula request

Posted on 2014-11-12
7
78 Views
Last Modified: 2014-11-12
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
0
Comment
Question by:pedwards3
  • 3
  • 2
  • 2
7 Comments
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40438525
please find attached
excel-example.xlsx
0
 
LVL 8

Expert Comment

by:itjockey
ID: 40438532
See attached
excel-example.xlsx
0
 
LVL 8

Expert Comment

by:itjockey
ID: 40438533
opppsss Sorry
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:pedwards3
ID: 40438612
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
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40438707
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
 

Author Comment

by:pedwards3
ID: 40438934
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
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40438942
in that case regardless of the alphanumeric. the criteria of containing 6100

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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Extract Unique List when in Two Columns in Excel 20 27
VLOOKUP 6 17
Excel Charts: How is this Chart made? 8 29
Embeded Images 13 8
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question