Excel Tutorial - COUNTIF, SUMIF, and AVERAGEIF functions

#Excel
#HowTo
#LinkedIn

[talhatheoptimist]

Thanks for such an eloquently made presentation

[ahmedanwar]

thanks at first for that great effort. but pls answer me about that inquiry.
when i tried to make a table and insert some data to know if ive learned how to insert COUNTIF function very well or not, the last two tabs didnt work correctly. 

[ndtvcnn]

it was an useful information - I need an help how to count number entries per half an hour. Example - from 12.00 - 12.30 pm 5 boxes are packed like 12.05 - 1  box no 1001, 12.15 - 1 box no 1002, 12.20 - 1 box no 1003, 12.25 - 1 box no 1004 and 12.30 - 1 box no 1005. How to count number of number of boxes packed every half an hour instead scrolling on box numbers and find the count at the bottom. Will countif formula can be used.

[janroesch]

thanks for the great info! I am wanting to learn how to create a formula similar to sumif ... but over a spreadsheet with multiple sheets... any suggestions? thanks :)

[shamsulhaq]

Please add the excel link as well so that we practice with your example. thanks

[shaktimehra]

good one ....thanks for sharing the video

[darkhandz]

good video man! helped me a lot, thanks a lot!!!

[kurapikanostrad]

What if i pasted a couple of numbers vertically with some letters on it and even comma, and I wanted to delete it or sum the all numbers? Because I cant delete each letter on 430 items so that can Sum it all?

[jameswilliamson]

If i go to a clean sheet > formulas > math & trig > Combin ( not combina ) > Number is 20 > number chosen is 5 = answer 15504. Question, How can i list each of the 15504 answers into seperate cells in a column.

[proudbSAcan]

Great, thanks for sharing.
How do I use the wildcard option in COUNTIF to add the total call outs on each day of the week if the dates are entered as DD/MM/YY, but displayed as long date?

[vedanthbaliga]

How do you get the "search" option in the filters tab in windows 7

[louisewooding]

Thank you for the video - very useful.  Is this file available for download?

[Apple-Bay]

hi i would like to ask for your help, i meed to created a price list but is a bit complicit as im not usr to excel
im planning to buy stuff and they are different grade of the same product
example : grade A = 100% Grade B= 85% grade C 65% and so on
many thanks
pd: im subscribed to lynda.com but can't ind it

[mohamedelmohandes]

how can column h which is the salary be the same as the sum of full time employees

[lynntony]

I just want to know how to copy formulas to calculate the rest of the page!!!

[hrindia]

HI SIR
I am using excel 2007 version sumif is retuninh zero value plz me know what mistake ihad done

[shamira]

can someone pls help me

A B
1 High. Manager
2. Low. Officer
3. High. Supervisor
4. Medium. Manager

How do I count how many managers on high?

As per above it should be 1 but how do I create a formula on excel?

[jonathancasanova]

Neil de Grasse Tyson narrated this? :-D

[michaelfreeman]

i didnt know neil degrass tyson did excel help

[fivesfish]

That's wrong! Your data should be in a Database and you should of created a report. The report would show the information you needed, ie, how many people worked full time.
Excel is for math!