ms excel formulas

sum =SUM(B3:B14)
sumif  =SUMIF(B3:B14,"<100")
count  =COUNT(B3:B14)
counta  =COUNTA(B3:B14)
text =COUNTA(B3:B14)-COUNT(B3:B14)
count blank =COUNTBLANK(B3:B14)
total cells  =COUNTA(B3:B14)+COUNTBLANK(B3:B14)
average =AVERAGE(B3:B14)
min =MIN(B3:B14)
max =MAX(B3:B14)
small =SMALL(B3:B14,1)
large =LARGE(B3:B14,1)

Comments

Post a Comment

Popular posts from this blog

What is MS Word

Image
kkj 1-What is MS World? M, S, the world is a software used to English or Urdu is written and published.MS World 'proper editing can also be written in English.  For example, Heath's character, characters, etc. The size and color can be changed easily. If so write books that can be written in MS asayny things in the world are written in the book world in the MS can be easily set . kkj 2-What is a Cover Page and how is it used? Home page is the cover page of the book.  Each book is made up of a page of the book contains some information etc.. Example, the topic of this book has been written on this book and the name of the company that published it And name of the person who set it It was published the year the flower .  MS; World., I already have a cover page design by,According change we can make your subject. MS, World I have to get cover page cover page option Insert the option of clicking on the cover page  Click on the cover page of the layout of one of hs
Read more

EXCEL FARMOLAS

Image
Excel formula to gather all uyluz 1,  =SUM(A1.A20) 2, =SUM(A1,A10) 3, =sum(A1,A10,20) 4, =sum(A1,A10,C1:C10) Excel formula 2 =sum(Ceal1+cal2+cal7+cal10) counat farmula: 1,  =counatblank(A1,A100) if formula , 1=if(and(A1>5,B4<1000),5000,0) =IF(and(C4,.70,G4<20),"pass","fail") Excel to enter the date and day, formula =date(2013,03,03)
Read more

Microsoft Outlook

Image
  kkj v 1.What is Outlook? v Microsoft Outlook, Microsoft's personal information manager, is available as part of Microsoft Office. Current version Microsoft  v Microsoft Outlook, Microsoft's personal information manager, is available as part of Microsoft Office. Current version Microsoft Office Microsoft Office Outlook 2013 for Windows and Mac is for. v Although often mainly as an email application is used, except that it also is used for purposes such as a calendar, task manager, contact manager, note taking, a journal and web browsiAs a standalone application that can be used, such as shared mailboxes and calendars, or, Exchange public folders, SharePoint lists and meeting schedules for multiple users in an organization and the Microsoft Exchange Server Microsoft SharePoint server can work with. Third-party applications such as BlackBerry mobile phones and other office as Skype Internet communication software included with the tools to integrate with Outloo
Read more