May 3rd, 2010
See how to count with multiple criteria! See how to do it with the new Excel 2007 COUNTIFS function and see how to do it in Excel 2003 with the SUM & IF functions in an Array formula (Don’t forget Ctrl + Shift + Enter). See that the new Excel 2007 COUNTIFS function is a much easier solution than was available in earlier versions of Excel. See how to get a count of the number of sales for a department AND a Product. Count values between Upper & Lower Value. Count values between an upper and lower bound. Count Values based on Two Conditions. Count Values based on two criteria. Count Values based on multiple conditions criteria. Count values between an upper and lower Limit.
Tags:
Dear meshugina1,
Are you referring to the class “121ExcelAccgt”? If so, they are no long avaiable. I made those videos with a much older program and it never worked very well.
Sorry about that.
But any of the other videos or files that are at my college web site, you can use.
–ExcelIsFun
Hey I noticed on your web page you teach a class, Excel for Acctg, The videos on your page are expired. Is there any where I can see these or go through the course material? Seems like something that would be cool to know.
thanks
Dear kennis942,
Hey, tell me how you do that? How can you download a YouTube video? You know, I may know how to show people how to use Excel, but I am pretty new to YouTube and I don’t know many tricks….
–ExcelIsFun
–ExcelIsFun
well then i wuld have to go thru your entire 241 videos and download them seperaqtly …:/
Dear kennis942,
I do not have a list of urls.
–ExcelIsFun
do you got a list of Urls to all your videos atleast?
Dear kennis942,
They do? Rad! Cool! But if it is only the current one, then I guess that is not so good.
As for getting them from me, at this time, it’s not going to happen. This is my little hobby that I do on the side and otherwise I am so busy with work and family.
–ExcelIsFun
actually it dos but only for the current video, but what i was asking was if i culd get them from you? ( i know it is possible)
Dear kennis942,
No, YouTube doesn’t allow that.
–ExcelIsFun
funny…
i need to ask you sumthing..
is there any way that i can download all your videos , becus i want the freedom to not have internet, becus in the nearest future not have internet…
Dear kennis942,
I’ll keep making videos regardless of whether you rate or not, but if you rate, I’ll be happier. But if you don’t, just use the Excel function =PLEASEREMEMBERTORATE(Videoname,Yourname).
Just kidding!!!
Thanks for watching!!
–ExcerIsFun
i watch but i forget to rate, but if i didnt forget it i wuld vote {This is a fracsion: (Awsome^Awsome)awsome}
Dear kennis942,
EXCELlent!!!!!!
You keep watching and rating and I will keep making them!!!
–ExcelIsFun
yeah this is like a self studying sc
thank you!!!
hool on excel with no teacher
Dear tengun1,
I’ll keep making more entertaining Excel videos!!
–ExcelIsFun
Thank you! You make learning Excel really entertaining.