Excel: Sumif, Countif, Sumifs, Countifs
Тәжірибелік нұсқаулар және стиль
I show you how to do basic summing and counting based on criteria.
Donate: www.paypal.com/cgi-bin/webscr...
These are really useful functions. If you want to follow along the data lives on this web page. You can simply copy and paste it into excel .
http:--www.contextures.com-xlSampleData01.html
/ mattpaul25
Пікірлер: 69
Dude...you have really made what was a dark cloud for me into a really bright sun shiny day!! Thanks!! Do you have site with more videos of this nature?
@YourXLNerd
8 жыл бұрын
+Glenn Campbell Thank you! glad it helped.
@teachandtrained3985
4 жыл бұрын
kzread.info/dash/bejne/nqhtrcSCfse5c6Q.html
Brilliant & Bravo Maestro! Your work lives on 11 years after you put this KZread video up. I have been tearing my hair out trying to figure out a problem and your lesson got me through it! Many thanks for your good work!
You have no idea how much you have provided some clarity on how this works. You are a lifesaver!
@teachandtrained3985
4 жыл бұрын
kzread.info/dash/bejne/nqhtrcSCfse5c6Q.html
Million thanks for showing me how to solve the excel problem that we have in our daily work.
The great Tutorial. Whats i looking for 2 years.
Very good video...much better explanation than Microsoft Press gave (or didn't give) in Microsoft Excel 2016 Step by Step.
Thanks so much for this simplified illustration. it helps a lot.
Thank you for this video! It really helped me understand Sumif and Countif!! Yay!
u r awsum Sir, i like d way u teach so clearly..
Thumbs up for this bro! This helps a lot for me. Thank you and God bless.
Just what I needed. Great Job! Thx
OMG. I am taking MIS, Managing Information Systems, and we have to do an excel sheet that has these formulas in it. This helped me so much. I really hope the formulas are correct!
@YourXLNerd
9 жыл бұрын
they should work - but you are going to use them in different ways in practice
Awesome video man! Thanks for the help!
Awesome tutorial! Thanks, this really helped! :D
Thanks for video ! You seems to have made it easy.
Finally i got this tnx bro
Excellent work!
Good one,helps a lot. Thanks
Thanks sir!! You help me a lot.
Thanks alot for the help!
helpful tutorial thanks :)
Very helpful. Thank you
Thank you very much Bro....
Thanks. What is the need for the ampersand when adding the date criteria? Seems like an unnecessary extra.
Bro thanks a lot 🙏
2:16 sorry what are you saying? how did you go back to the formula? what did you press? thank you
Great tutorial
hi Matt, at 3:59 in this video , there is a text filter page , please give any of your youtube URL if you made, i want really learn this kind of text filer page
Hi, You video made me understand these concepts more. Can we do countifs on the row cells or its just on the coloumn cells. thank you.
@YourXLNerd
7 жыл бұрын
you can do it on any range - whether vertical or horizontal
@YourXLNerd
7 жыл бұрын
you cant do it on a vertical AND a horizontal range, so long as the ranges are parallel and equal size you shouldn't run in to any problems.
nice job. given the file sir
Thank you so much.....
HI Matt, how did you select the column C like that?? I always need to drag the whole thing down manually... :/
@muathsaraireh
8 жыл бұрын
+Bella Z Ctrl + Shift + Down
i learned everything you showed me here but i did not understood the 'since order date' sumifs value is 64.( 10: 24 to 10: 26). could you please illustrate it for me? it would be great. i am very thankful to you dude!
Hi Matt, Do you know how you can count how many time several different things occur? So if in one cell I want, say the total times Binder, Pencil and Pen occur in one column? My actual problem is I am using ordinals, 5th, 6th, 7th, 8th, 9th & 10th. I want a total of how many times a person has finished 5th-10th. Here is the formula I've used successfully to total the number of times a person finished 1st; =COUNTIF(B7:B41,"1st"). I've got individual cells for when they finish 1st, 2nd, 3rd & 4th and I use the same formula, just change the "1st" to "2nd" etc. Now I want at total in one cell of the number of times they finished somewhere between 5th & 10th. Can you help me please?
Thank you
If I want to count number of particular reps. Like jones and morgan. Can we find that using countifs?
@YourXLNerd
5 жыл бұрын
You could do a count if + count if
do you have the same excel sheet with the data so we can follow? Thank you!
@YourXLNerd
6 жыл бұрын
www.contextures.com/xlSampleData01.html
Bro i would like to know how ... u put up that sumif sumifs bar.. that keep on automatic calculation.. plis can u help me up.
@YourXLNerd
8 жыл бұрын
the formula should update automatically. If not you need to go in your excel settings and turn on automatic calculation. should be easy to google.
How do I get my f4 (to lock cells) works?
good bro.
Awesome
What if I want to sumif I have negative and positive numbers in the same column?
Hello. I am a bit stuck. Can somebody help, please. Here is the situation: In an Excel document. I have a column that contains names. I need to put in a new column all the names that are mentioned once; and on another column all the names that are mentioned twice; this up to 5 times. Thanks in advance.
HI i need to delete two same names, i use duplicate , but it remove only one name , i need to remove both names . Example ( boby, steve ,jeff, steve , evan ,eric ) need to delete both steve names . any formula please.
I'm new at Excel and I recently constructed a Home Monthly Budget Planner. I'm wanting to only add the year's amount if the Bill has been paid. Can someone help? Here's an example: Gas Bill - January Due Paid - February Due Paid - March Due Paid - April Due Paid......December Due Paid - YTD $86 X $76 X $56 X $74 X X $218 I only want to add the months that have an "X" in the Paid col. Can someone help me with the right Formula? Thanks!
👍👌👌
I have a spreradsheet where I need to perform the following. It is all in one row and on two worksheets. I am having a heck of a time figuring this out so if you can assist I would reallt appreciate it. Condition 1 ('Sheet2'!B8:AF8,'Sheet2'!A8,F2="Jun") Condition 2 ('Sheet2'!B2:AF2,
@YourXLNerd
9 жыл бұрын
Richard Pearson im not sure i understand the conditions - is that apart of a sumif formula?
@richardpearson3285
9 жыл бұрын
That is what i am trying to do yes
Thanks
OK, found correct link that you posted below under "Masterofplay7": www.contextures.com/xlSampleData01.html. Thanks
Cool
good
the link for the sample data does not work: http:--www.contextures.com-xlSampleData01.html .can you fix it?