How to Count in Excel Sheet

Count in Excel Sheet is very important Formula in you use the conditional. In this article, we mention how to count in excel? also, the count on condition based. We learn in the previous tutorial about VLOOKUP formula in Excel Sheet.

Let's go start the work on count formula if they conditional based and without conditional how count formula we used? When you used Count Formula. You have a lot of data and you want to count some the value on conditional how many they are at that time count formula work to you?

Let's Start, Here available two columns in Excel Sheet  below

This two column one is debit/Credit Mark and another is an amount. We found a conditional based Count of debit and credit in this tutorial applying simple count formula in excel sheet.

Count Formula : 

=COUNTIF(C3:C19,"C")

Formula Description :

C3 is C column name and 3 is Row number where are you start the condition. Here the same C19 C is the also C name and 19-row number is you to end of your count search. In the double quotation, C is the conditional which you want to count here is too conditional one C and another is D.Below Figure I am clear to you.