Learn How to Use COUNTIF in Filtered Data in Excel | Count Visible Rows Only in Excel

Learn How to Use COUNTIF in Filtered Data in Excel | Count Visible Rows Only in Excel
Learn the excel formula to count the special value from the filtered data in Excel. Using COUNTIF in total data is easy, but in case of use of COUNTIF in filtered data, it will be too difficult. This video has provided solution to this.
#advanceexcel #excelformula #exceltips #office365 #exceltraining
Download the practice workbook used here in this video tutorial from the link below.
spreadsheetlea...

[@DavidMacDiarmid-j6z]

The most straight forward explanation of how to solve this problem. Amazing video. I spent an entire day trying to figure out a solution. So happy I found this tutorial. The best seven minutes I have ever spent on Excel learning.

[@smart-office12]

Thank you 🙏

[@olufunkedaniels174]

I had same experience, got stuck on a problem and I literally spent over 12hrs trying to solve. Thanks to "Smart Office" for this short but detailed video.👍

[@FloraWong-g7h]

Thank you so much for sharing. It's very useful. Many thanks!

[@Carlanga3533]

Thank you man, I had done this formula before but didn't remember, you presented it the easiest way possible.

[@wendytchoe]

Is it possible to do this if you you have multiple criteria? For example, if your original formula was =COUNTIFS(C6:C20, "RPA", D6:D20,"Present") and you wnat to filter for Manager A.

[@hectorruval7666]

This is extremely helpful. Could you please explain how to count blank spaces while filtering data? In other words how to count blank spaces with specific criteria from filters. I am using the COUNTBLANK formula but it counts all the blank spaces from the column and I would like to try to get numbers after filtering information. Similar to what is being done in this video, but counting blank spaces instead of words.

[@oooborn-s2g]

I respect you on behalf of all of koreans...감사합니다

[@smart-office12]

Thank you 🙏

[@samarhabibi4524]

Thank you! This is so well explained and has saved me mass amounts of time!

[@smart-office12]

Welcome 🙏

[@radking4410]

How can I like this video several times?????? Thank you so much!!

[@smart-office12]

Welcome 🙏

[@DaleWilkins-x4f]

Its not often i go to KZbin and get exactly what i want when trying to resolve an excel issue. This one is excellent, well done and thanks.

[@smart-office12]

Thank you 🙏

[@DaleWilkins-x4f]

Is it possible to sum a total value as opposed to count@@smart-office12

[@DaleWilkins-x4f]

Hi there, don't worry, I've solved it

[@Hells_Gift_MB]

Amazing video, thanks mate! No one else covers this stuff, golden material.

[@smart-office12]

Welcome 🙏

[@amBRC10]

Great vid! Thanks. How can I add the condition of =">today()" ?

[@iant.1356]

Fantastic video, short and to the point Truly amazing how often sb with an indian(?) accent has saved my day with a short youtube clip

[@smart-office12]

Thank you 🙏

[@vikashrajr8293]

Thank you very much. It's very much helped for my report.

[@teeceemuzik]

Wow thank you, it works! Don't ask me to explain the formula though.

[@smart-office12]

Great 👍

[@Michael-wd4oz]

good video mate , this solved 3 hrs wasted at list , thank you

[@smart-office12]

Thank you 🙏

[@UnwantedCommentary]

How do I do this with a conditional where the condition is that a value in the column must be greater than 0? Also I am not sure if it is messing up for me because I am using table format for my column data such as "Table[Cost]"

[@smart-office12]

In the place of N(D6:D20="Present") Change it to N(D6:D20 >0)

[@UnwantedCommentary]

I will try that. I had been using ">0" so I will try without the quotation marks@@smart-office12

[@lokeshmadankar2420]

Really helpful. Thank you

[@smart-office12]

Welcome 🙏

[@jacobnorman4304]

Thank you very much for the helpful video.

[@smart-office12]

Welcome 🙏

[@naziralifarooq5899]

Can we use same formula on google sheet?

[@iso_ix7405]

Bravo! Thank you soo much!

[@smart-office12]

Welcome 🙏

[@stnicholas296]

Thank you, this was extremely helpful.

[@smart-office12]

Thank you so much 🙏

[@binapark9208]

Very helpful

[@smart-office12]

Thank you 🙏

[@raknan75]

Thank you so much

[@smart-office12]

You're most welcome

[@janerichardson3493]

good stuff, thanks

[@smart-office12]

Welcome 🙏

[@Democratic_Spirit]

Thank you very much it works well

[@smart-office12]

Glad to hear that

[@chronixlovee]

What if I am trying to count the number of cells greater than zero? my table has "hours late" where your "attendance" column is. I am trying to count the number of cells greater than 0 when data is filtered.

[@marknewton3203]

Thanks, much appreciated

[@smart-office12]

Welcome 🙏

[@pratibhaacharya1195]

Very nice 👍👍👍

[@smart-office12]

Thanks a lot

[@GeneralGyan1.0]

Thanks for this my friend.

[@smart-office12]

Very welcome

[@ailyen]

In my case it's not text it a number; I want to know how many 90 I have after filtering it just shows me 0. Here's what I used: =SUMPRODUCT(SUBTOTAL(3,OFFSET(O8:O400,ROW(O8:O400)-MIN(ROW(O8:O400)),,1,)),N(O8:O400="90"))

[@smart-office12]

In case of numbers, it should not be enclosed with double quotation "90", only keep 90

[@edakochi]

If to figure out greater than a particular number then? For example greater than 1

[@dulalchandra7624]

Hi, how can I count the unique value in the B column subject to the D column Value?

[@rishabhgupta3797]

not working in google sheets sumproduct mismatch. Anyone Help

[@haniharshith5174]

I am getting the error "SUMPRODUCT has mismatched range sizes. Expected row count: 1. column count 1. Actual row count: 107. column count: 1." Please help me out with this

[@hassanidrees6130]

Superb, thank u so much ❤

[@woojiskanaamnahiliyajata1462]

Very nice, but it not working in google sheet please help me

[@gnospanker]

Is there a way to count if the cell contains "present"? I have this working but I'm trying on a column that has the word "yes" and then a date (ex: "yes 1/24/24"). I try to just use wildcards in the formula as show above but it's only counting the cells that are "yes" and not "yes 1/24/24". Here is my formula... =SUMPRODUCT(SUBTOTAL(3, OFFSET(X2:X126,ROW(X2:X126)-MIN(ROW(X2:X126)),,1,)),N(X2:X126="*Yes*")) Notice my attempt to use * wildcards around Yes

[@muhammadarif6455]

How about the value more than one ?

[@akshaythakur6484]

How do I use countifs function in filtered data?

[@HenryPeople]

Thank you so much!

[@smart-office12]

Welcome 🙏

[@andersonyork48]

Thank you!

[@smart-office12]

Welcome

[@JawedJami]

This formula worked to count "text" but not the "digit" like 1, 2, 3, how to count digits please?

[@alexanderv4609]

For digits you just need subtotal

[@nishantupadhyay5368]

Facing the same problem...i have given remarks like no 1 for present and 2 for absent then how we count it...

[@RománValverdeBelaustegui]

i get this error: SUMPRODUCT has mismatched range sizes. Expected row count: 1. column count: 1. Actual row count: 196, column count: 1.

[@smart-office12]

Could you plz share the file, [e-mail] i will check for the error

[@scoleman7862]

Did you have a reply for this error as I am getting the same in Google Sheets. It would be great if you can make this work in Google sheets and demonstrate this as there are a ton of people asking for this solution online and do not seem to be able to make this work in sheets. Thx@@smart-office12

[@TheJesusGutierrez]

Was there a solution for this?

[@JoePantalone-r1q]

I am getting the error "SUMPRODUCT has mismatched range sizes. Expected row count: 1. column count 1. Actual row count: 1276. column count: 1." This is the formula I typed in: =SUMPRODUCT(SUBTOTAL(3,OFFSET(V8:V2000,ROW(V8:V2000)-MIN(ROW(V8:V2000)),,1,)),N(V8:V2000="*CASH*")) I want it to count every visible instance of the word CASH in the V Column. There are multiple variations of CASH (i.e. CASH 1, CASH 2, etc).

[@smart-office12]

Hi, could you please share your file to [e-mail] I will check for the issue and revert

[@A96000]

This is exactly what I was looking for. 0 explanation. Here is how you do it. FINISH.

[@edakochi]

How to count number?

[@smart-office12]

In case of counting numbers, do not use the double quotation marks.

[@backofficearchtech6250]

with countif i want to know todays absent and present

[@umesh0512]

Quite complicated

[@zainabejaz7235]

I got 0 count

[@smart-office12]

Please share your working sheet (if possible) to [e-mail], will check for the issue and revert