How to use Subtotal with Countif Condition in Excel

While we are working with dates in excel, often we have to add or subtract the dates from each other. Sometimes we want to calculate a specific date (past or future) with reference to another date in our data set. You need to do such calculations when you are managing a project with specific timelines, … Read more

One thing is very important to know that the function SUBTOTAL is normally used to operate on a filtered dataset. We can then apply many possible operations on the filtered data using SUBTOTAL e.g., SUM, COUNT, AVERAGE etc. However, SUBTOTAL can’t be used in conjunction with COUNTIF, because COUNTIF returns only a single number and … Read more