Count of a Specific Text / Number / Date in Multiple sheets of an Excel workbook

This video discusses a combination of Countif and 3D sum for returning the count of specific Text, Number or Date in multiple sheets of an Excel Workbook.
🟠 Books on Excel xlncad.com/exc...
🟡 Get Office 365 Subscription microsoft-us.e...
🔵 Download my free ebook on Excel Macros eepurl.com/gpT0RD
🟢 Read my articles on Excel xlncad.com/
🚚Check my store on Amazon.
www.amazon.com...
Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won't pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!

[@noorudeen2914]

Thank you for your help

[@10morrisonka]

First and the best - classics !!💖💖💖

[@AjayAnandXLnCAD]

Thank you Miss ☺️😇🙏

[@atiqurrahman1962]

Thanks a lot but is it possible to get the sum result with a single formula?

[@atiqurrahman1962]

Amazing trick! Sir can you please help me to count a specific text from multiple columns from multiple sheets. Please help me.

[@sssagar4017]

First sort on date, then item then defect wise total in next sheet

[@theinterestsofmaria3472]

I just want to ask if the status as per clasification, how is the countif for multiple status as per the classification, hope you could help me

[@AjayAnandXLnCAD]

You should go for COUNTIFS function when there are multiple conditions to be evaluated. Pls check my video on COUNTIFS function.

[@meganwallace1642]

This is helpful but how do I count the sum over multiple sheets?

[@AjayAnandXLnCAD]

Can you explain pls

[@pakkruikkru]

SUPER ...

[@AjayAnandXLnCAD]

Thank you 🙏

[@danielkristoff9660]

Thanks for the upload. I really need some help with this Countif formula. I have a sheet with a large amount of data. I have name initials, dates, and numbers on it (for example 23/04/2021 - KZ - today's errors "3" ) I have 4 different sheets for summerise every week's data and I want to display the number of errors but only for the relevant weeks. Sorry for my bad english I'm just a beginer. Thank you in advance!

[@sssagar4017]

Sir, if i need to total of perticular item, defect wise,date wise in 2nd sheet. How can i do?? Like one item production whole month

[@desidost7035]

Can you solve please There are 2 columns. first colum will be names , 2nd column will be some numbers Now in 1 colum there are many names repeated in 2nd colum there are different numbers Now I need to marg repeated names and count total numbers in second colume against the repeated names Please give suggestions how clear with formula instead of using pivot tables Thank you In 2nd colum

[@simonsiagian6725]

Sir, may i ask. is it possible to countif some cells sequence pattern condition. example from cell a1 to a10 contains each 1 6 3 4 5 3 4 8 9 1 (3 and 4 are the pattern) and based on the example the results should say 2, thanks