Article: The setup for this data table is much like for SUMIF, but it can support multiple criteria differing ranges. Make a column with numeric values, a second column with a conditional value (e.g. yes/no), and a third column with another conditional value (e.g. date). Select a cell and enter “=SUMIFS()”. Within the parentheses enter the summation range, criteria ranges, and target criteria. Important to note, with SUMIFS the sum rage is the first value. For example, =SUMIFS(B1:B4, C1:C4, yes, D1:D4, “>1/1/2011”). This will calculate the sum of column B, as long as column C has the condition “yes” and column D reads a date later than 1/1/2011 (“>” and “<” are symbols used to denote greater than and less than). Note that the ranges can be variable, which can be useful for large data tables.
Question: What is a summary of what this article is about?
Setup your data table. Enter your SUMIFS function.
Article: With so many styling products available, there are plenty of options to help enhance your natural curl while fighting off unwanted frizz.  Products like gels, mousses, and curl-enhancing creams all contain ingredients called polymers, which coat the hair and “lock” your curl or wave into place. If your hair is fine and wavy then mousses are your best choice since they don't weigh hair down. If your hair is coarse and curly, gel or cream is recommended. Most hair sprays and mousses have a high alcohol content, which can cause the cuticle to swell up. Alcohol can also dry out your hair, making it look poofy and eventually leading to breakage. Try using alcohol-free products that work to reduce frizz, such as creams and serums. If your hair is damaged from dye, or just naturally dry, a boar-bristle brush can help to reduce frizz. This type of brush helps to gather the natural oils from your scalp and distribute them throughout your hair. It may seem counterintuitive, but wrapping flyaway strands around a curling iron can help set them in place and smooth out your hair. Be sure to completely dry your hair first and use the curling iron sparingly. Keep it on a low heat setting and don't hold the strands for very long. Whenever you use heat, you risk causing damage to your hair. Always apply a heat-protectant product first. A hot oil treatment is a great way to condition and strengthen your hair. This is a good idea for all hair types, so try it out with your friends. Choose a treatment with jojoba oil to help strengthen the cuticle and further prevent frizz. Warm up the oil then massage it into your hair and scalp.  If desired, you can put a shower cap over your hair and let the oil soak in for 30 minutes before washing it out. You can help the oil penetrate deeper into the hair shaft by applying heat with a hair dryer.
Question: What is a summary of what this article is about?
Let your natural shape work for you. Switch to alcohol-free products. Opt for a boar-bristle brush. Tame flyaways with a curling iron. Do a weekly hot oil treatment.
Article: Try to be prepared for every lesson so that you can follow along easily. Make sure you have the right supplies, books and completed assignments for each lesson. When you go into class, be ready to learn. When you're doing your homework the night before, write down any questions you have about it.  Make sure to ask your teacher those questions the next day. This will show your teacher that learning is important to you. Try not to drift off or get distracted. If the teacher asks the class a question and you know the answer, raise your hand. Get involved in group discussions whenever you can. When you do join in, never talk over a classmate or interrupt your teacher. If you aren’t sure how to join a class discussion, ask a question.  You could say something like, “Mrs. Bell, can we talk more about the main character’s motivations in the book?”  You could also say something like, “Mr. Turner, can we please go through that equation one more time? I’m not sure I understand the last part of it.” When the teacher gives in-class assignments, always do them when you’re supposed to. Work during the work period provided so that you can finish your assignments on time. Try not to distract anyone nearby who’s also working on their assignments.  If you have a question about something on the assignment, raise your hand and ask the teacher politely for help.  Then say something like, “Ms. Miller, I’m not sure if I understand this part of the assignment. Can you explain it?” After the teacher helps you, always say “thank you.” Always doing your homework is a way to show your teacher that you care about the class and what you're learning. Teachers work long hours teaching kids all day, so when students don’t do their homework or complete assignments, they feel ignored. Teachers, like everyone, want to feel that what they do matters. When students show that they are learning things, it makes their teachers happy.   Doing your homework is one of the easiest ways to be nice to your teacher! If you’ve been out sick and missed class, always ask your teacher what you missed. Be sure to get your makeup assignments and homework. Whenever the teacher asks you to do something specific, be sure to follow their directions exactly. Do your assignments the way the teacher told you to. Whenever your teacher verbally asks you to do something, always do it without making a fuss.  Never do anything disrespectful, like make a face or roll your eyes, when the teacher asks you to do something. If you don’t understand the directions given, don’t be afraid to raise your hand and ask a question or for assistance. Never make excessive noise or talk to your classmates during a lesson. Don't shuffle papers around loudly, dig noisily in your back pack or slam books around. This will interrupt your classmates’ concentration and your teacher. If you can’t pay attention when you sit by your friends, try sitting elsewhere. You can save small talk with your friends for after class.  If you have assigned seats, go to your teacher privately after class and ask to be moved. Let them know you'd like to be moved so that you can concentrate on lessons better. Your teacher will appreciate that you are taking an active role in your education.
Question: What is a summary of what this article is about?
Be prepared. Participate in lessons. Work on your assignments when instructed. Do your homework. Follow directions. Avoid distracting other students.