COUNTIF Function in Excel

COUNTIF



"COUNTIF" can be used to count cells that contain dates, numbers, and text.

=COUNTIF(D5:D12;">100")  => count cells where greater than 100 between D5 and D12.

=COUNTIF(B5:B12;"jim") => count cells where equal to "Jim" between D5 and D12. 

=COUNTIF(A1:A10;"<"&B1) => count cells less than B1

& => after quote if you want to write excel variable, type it before the variable.

=COUNTIF(A1:A10;"<>red") => count cells where not equal to "red" between A1 and A10. 

=COUNTIF(A1:A10;"<"&DATE(2020;4;1)) => count cells where greater than the date between A1 and A10.

=COUNTIF(A1:A5;"???") => count cells where contain 3 characters.

Yorumlar

Yorum Gönder

Bu blogdaki popüler yayınlar

Detecting Unique Data in Excel

Resim
Unique Data Filter 1-Click "Data" Tab on Menu.  2-Click "Advanced" next to the "Filter" on Ribbon Menu. 3-Tick "Copy to another location" and fill the form like this.     List Range => Select your data on Excel page     Copy to => Select location where starts your unique data.     Tick "Unique records only". Delete Duplicate Data 1-Click "Data" Tab on Menu.  2-Select your data. 3-Click "Remove Duplicate" on Ribbon Menu.
Devamı

What You Need to Know About VLookup Function in Excel

Resim
  VLookUP (Usually used for unique data) 1-First, you choose the cell where you want to add listmenu.Then click "View" on Menu. 2-Click "Data Validation" in Ribbon Menu. 3-Select "List" in Allow Menu. 4-Click "Source" input and select your data where u want to search. Now let's get data according to the variable in the menu. 1-Write " =VLOOKUP( " in function area; 2-Select the list and type ";". 3-Then select all data where we search martial status for matched name with the list. (Name-Martial Status Table) 4-Type ";" again and write the column number we get data from selected table (2.column) 3-Type ";" again and write "0" for exact match.(OR "1" for approximate match)  4-Close the bracket.Then Click Enter. Other method => You can write same function by clicking Fx and fill the form. final formula  : =VLOOKUP(A8;A2:B6;2;0)
Devamı