Google Sheets - SUMIFS, SUM Functions Intro Tutorial

Video tutorial about SUM & SUMIFS functions in Google Sheets. You will learn how to apply conditional summing in Google Sheets.
Google Sheets
www.google.com...
Website:
www.chicagocom...

[@onechanceva]

By far the clearest and most applicable lessons on spreadsheets I've found online. Thank you.

[@ExcelGoogleSheets]

Wow, thanks!

[@billparsons7732]

The best teacher on the NET, I'm so thankful.

[@nanaarhin5567]

Thanks bro, you're a very good teacher. I was able to configure it before I finished watching the video. Keep it up with your tutorials

[@jasonweston3769]

Instablaster.

[@medaho]

Now I better master the function Sumifs.Thank you for your clear explanation and by guiding us step by step (After understanding and testing successfully with my example I came back on your channel and suscribed.

[@globelinkfk]

Subscribed. Very clear narrative. The shortcuts taught are gems too. By the way, what if another condition is put into the formula. Eg. I want the sales total BUT NOT to include sales from CA. Please show how to go about it.

[@SurvivorJoshua]

Question here: If i want multiple criteria here that is text based, how do I go about that? ie: sales of both New Balance and Adidas

[@philiphorton1661]

That helped me so much, Thank you for taking the time to create the video

[@ExcelGoogleSheets]

👍

[@pavlozhdanov.]

Thanks for sharing, that is helpful and clearly mind

[@oatsymeow1761]

What is the SUMIFS formula if I want to sum both NIKE and NEW BALANCE. Is it =SUMIFS(SUM RANGE, CRITERIA RANGE, CRITERION1, CRITERION2) or =SUMIFS(SUM RANGE, CRITERIA RANGE, CRITERION1, CRITERIA RANGE, CRITERION2). I tried both and it didn't work.

[@ShubhankarDaptare]

Helpful video, thanks. Can you show how to use 'SUMIFS' to calculate 'DATA FROM MORE THAN ONE SHEET'?

[@markalvinmarana690]

Got one off of my list of to do list. Thank you 👍

[@GermanosChilli]

is it possible to get them in a specific month only

[@doseanator3]

love your videos! they are helping me automate my business. keep them comin'!

[@ExcelGoogleSheets]

Great to hear!

[@FanTazTiCxD]

I need help. I have a long list in one column, that says something like over 3.5 1,42 under 3.5 2,90 These are copied odds from a bookmaker that I want to paste into a spreadsheet to compare with other bookmakers. Nearby in the document, I have a column that says: Over 2,5 Under 2,5 Over 3,5 Under 3,5 Over 4,5 Under 4,5 ...and so on In the column to the right of that column, I was the odds to be shown. So for this example, I want the cell to the right of "Over 3,5" to return the value of 1,42 - since that's the odds of over 3,5 found in the pasted column nearby. In other words, I want to use a function that says: (For the entire column I have copied with information, I want this cell to be the value of the cell in that column that is located 1 cell below another cell that says "3.5", and two cells below a cell that says "over". If such a scenario doesn't exist, leave this blank) In my dream scenario, I can copy the odds from a given bookmaker into my spreadsheet, and it will automatically sort out the odds relative to the correct cells next to my own column with information about markets. Can anybody help med with a function like that?

[@scientificmaths]

Pls I need help on the use of checkbox and sun. For instance if I want only checked row added together in another column. I believe you should get what am saying...

[@TheCaptivatingDancer]

Thank you! Very useful video.

[@MaheshTumma007]

Thanks you for simple explaination

[@ExcelGoogleSheets]

😀

[@angkajitusuhuahongbanten6885]

hello could you help, how about if make with 3 conditions, Region Midwestern, Brand ADIDAS & CALVIN KLEIN, please help, thanks

[@ExcelGoogleSheets]

Video coming up next week.

[@erickkillian3952]

Thank you for the detailed explanation!

[@pushpendrasingh275]

Awesome. Great help 🎉

[@ExcelGoogleSheets]

Thanks! 😃

[@maxconstructioncarpentry1318]

This is really good. Glad I subscribed. I am trying to do the SUMIFS in a document with 2 dropdowns as the conditions. I can't tell if google sheets just doesn't perform this function with dropdowns or if I am doing it wrong. I've been trying different solutions, so maybe I'm just a bit confused by now and entering the syntax incorrectly.

[@ExcelGoogleSheets]

Please watch this kzbin.info/www/bejne/d3zWZJR7qcZ4gdk

[@cleverjel]

I want the criteria 2 base on date, how do I do that?

[@husnayahaya8546]

What if I want the sum of New Balance and Adidas from Midwestern and Northwestern? What will the formula look like? Currently I'm adding the SUMIFS, using =SUM(SUMIFS bla bla bla)+SUMIFS bla bla bla)+SUMIFS(bla bla bla). My formula became extremely long since I'm adding up multiple criterias from multiple columns

[@maryluzverdugo5053]

Hi, I have these example =sumifs('Registro Extras'!I3:I415;'Registro Extras'!C3:C257;F7;'Registro Extras'!F3:F257;U34) I want use sumifs but the criterias are in different sheets of the same file, but it results in · VALUE , what is wrong?

[@ExcelGoogleSheets]

Range sizes must be the same. I3:I415 doesn't match C3:C257.

[@maneet27]

if the cell contains other letters or space then NEW BALANCE. please help

[@matematiksel]

can i ask a question about sumifs? i write "

[@matematiksel]

i find it. it must be use "

[@ExcelGoogleSheets]

@@matematiksel 👍

[@raphaelgomes2947]

Is there a way to use sumifs to sum ranges based on criteria, but one of the criteria is an exclusion, like sum a number that is in criteria 1 but IS NOT criteria 2? Thanks in advance.

[@ExcelGoogleSheets]

use "criteria"

[@raphaelgomes2947]

@@ExcelGoogleSheets Thank you! The inside the quotations would never have occurred to me! It seems so unnatural lol. But it worked!

[@ExcelGoogleSheets]

The whole criteria part in these functions is counter intuitive. I often end up using FILTER with SUM to avoid the idiotic way the criteria works.

[@raphaelgomes2947]

@@ExcelGoogleSheets that's interesting. Work that work to make an exclusionary criteria type thing as well? And/or have you made a video about it already that will help me understand? Your videos are really good for explaining how the functions work, in a way that I understand how it works so I can use it in my own way without just copying and pasting your exact functions to get the desired results.

[@littledole]

Is it possible to use SUMIFs to search multiple columns for the same criteria? For example, if you had multiple columns of different sales types (retail, wholesale, etc) for New Balance - Could you search multiple columns to total all sales for "New Balance"?

[@ExcelGoogleSheets]

No. Use DSUM instead.

[@HaninosMaximus]

For those using chromebooks with no F4 function keys, the solution is the search button (search+4) it will do the same to lock the cells.

[@ExcelGoogleSheets]

Thanks for that!

[@devianairawati9192]

Hi thx for sharing. Is it possible to use the importrange function together with the sum if function in between sheets. I have tried but it comes out as an error. Tried querry function didnot work either.

[@ExcelGoogleSheets]

SUMIFS will not work with importrange, you'll have to use sumproduct or sum as array.

[@alexesparza4587]

Quite helpful.. I would like to change the cell reference based on a monthly sheet in the workbook without have to change all the cell references. For example my current formula is =Sumifs('Jan19'!$X$2:$X$400,'Jan19'!$C$2:C$400,D13). I would to have 'Jan19' reference a cell which would have another sheet for "Dec18" that is based on the month placed in let's say cell c10. I tried this but it diddn't work =Sumifs(c10!!$X$2:$X$400,'C10!'!$C$2:C$400,D13) with C10 being where I type in the new month. Jan19, Feb 19 etc. Thoughs?

[@ginstones4252]

How to do SUMIFS for case sensitive scenarios?

[@BoltDispatch]

This formula is not working on my google sheets.

[@rb8058]

Great video, very instructional, but wayyyy too many ads, KZbin. I really need to set up a Pi-Hole.

[@dmyuke]

So helpful! Thank you!

[@jamesputzulu8513]

thank you. Great video

[@KishoreKumarmaistry]

How to get a running total using a arrayformula?

[@Ava-Grace]

Very nice voice

[@gabrielpiffer87]

It's possible tu use an OPEN TERM in SUMIFS? Like "*yyyyyyyy*", but when this TERM is in a specific cell.

[@ExcelGoogleSheets]

Just use concatenation. Like "*"&A1&"*"

[@ronnyfr11]

Thanks! Simple, and even I understood it!! :))

[@eugenesoft856]

How about using SUMIF or SUMIFS with multiply criteria in single range? It's posible to sum: "New Balance" AND "ADIDAS"?

[@mreighties2860]

Hi Eugene, Yes, like this... =sum(ArrayFormula(sumif(E:E,{"ADIDAS","NEW BALANCE"},F:F))) ...or... =sum(filter(F:F,(E:E="ADIDAS")+(E:E="NEW BALANCE"))) James :)

[@mohammedkhalil6092]

If I have 3 conditions to sum How ???

[@ExcelGoogleSheets]

kzbin.info/www/bejne/d3zWZJR7qcZ4gdk

[@muhammadhatimaziz6310]

why it not working, it say value

[@mrs_varon]

THANK YOU!!!

[@edwinbelleza3568]

how about summing cells by color

[@EnglishSquared]

Very useful, thanks!

[@omarcosve]

Great

[@moogrin6687]

Thank you for this video! It helps me a lot :D

[@samlmac]

What does locking the cells do?

[@RobertSchechter]

I have the same question. Also, if you lock the cell range does that mean that you can't add rows? What happens when you add rows? Does that move the last rows out of the range so they are no longer part of the sumif calculation?

[@christinedwinatalia3773]

I also ask that.. What shortcut to locking the cell?

[@juanjlondono7893]

I wouldve loved to have the sheet data to follow along

[@hasyidanparamananda]

i make like this =SUMIFS(H$4:$H$30,$C$4:$C$30,"

[@ExcelGoogleSheets]

try =SUMIFS(H$4:$H$30,$C$4:$C$30,"

[@peterwright650]

Thank you

[@chris26087]

great vid but i have been on this for 1h and still get 0 at the end dont no whats wrong so going back to a calculator

[@chris26087]

woop woop for some reason it dont like the pound sign, work ok on 2018 accounts ?

[@ExcelGoogleSheets]

Share a sample sheet

[@HaninosMaximus]

Awesome!

[@Oliverwhitehurst]

What a beauty

[@VijayaraghavanKannan]

How to SUMIf using BG color? can someone helpme out :(

[@ExcelGoogleSheets]

Unless there is other logic to figure out why the background color is chosen, this won't happen without a script. You should be able to do this using apps script though.

[@СветланаПоцелуйко-ф5о]

Thank you!

[@gamalroissbagnaf6288]

===== we get 15 but i get 13 way (if i sum (1,12,0.5,1.5

[@mohitshukla5280]

Thanks

[@cuneiformscript2665]

🙏🏻

[@yahyasalih9548]

m9wwwd

[@ramirosalinas1061]

Very helpful! Thank you!