Sir when I am type this formula after the select of row when I type,'' or name of the thing it's say wrong could you please help me to solve this problem
Hi Chris, I am having an issue with a formula. I've used your tutorials to build everything except I cannot find how to do one more thing. I have a list of employees who terminated. I have their hire date and term date and want to count how many were here under 90 days (this one was easy) but then between 90 days & 1 year, 1 yr - 5 yrs, etc. Help please!
Hi it's nice video please can I ask you about one problem I am facing for doing count f formula for long numbers from Barcode Scanner more than 24 digit in one cell results coming not correct
Nice video Chris, I have one quick question, would you mind to explain how to use the formula if we want to find criteria "How many Karen Mcdonald who advertise on Radio"? Or for an example "How many James Robert who living in New York?" I'm really appreciate for your reply.
I'm going crazy, how do I count how many people were either rejected or accepted for either a manager position or junior position on a specific day i.e. how many people were rejected for the junior position on 01 January? I've tried sooo many different formulas and none are working.
Use *Countifs* function. Here are dates with accept and reject. I did accept. drive.google.com/file/d/16aH28nxGtdg81DpOpy278GnTR4A3KbX1/view?usp=drivesdk
How do I countIF it has two individual things I want to count? Example: 22 SL I want to count the 22 for an average & I want to count the SL for type of match (league vs league). So I want to count the 22 individually & count the SL individually.
than you ,
you realy save my day :)
Glad to help.
Helpful video
Glad to hear that Thanks, Ibeh Linda.
Sir when I am type this formula after the select of row when I type,'' or name of the thing it's say wrong could you please help me to solve this problem
Hi Chris, I am having an issue with a formula. I've used your tutorials to build everything except I cannot find how to do one more thing. I have a list of employees who terminated. I have their hire date and term date and want to count how many were here under 90 days (this one was easy) but then between 90 days & 1 year, 1 yr - 5 yrs, etc. Help please!
Hi it's nice video please can I ask you about one problem I am facing for doing count f formula for long numbers from Barcode Scanner more than 24 digit in one cell results coming not correct
What about if I want to count the amount of people in georgia who found us through facebook for example?
That would be COUNITFS (notice the S). Sample I created for you drive.google.com/file/d/1-VcIS7vhLBago9TGb6YK277uWj1-WCb6/view?usp=drivesdk
@@ChrisMenardTraining thank you, I really appreciate it
Nice video Chris, I have one quick question, would you mind to explain how to use the formula if we want to find criteria "How many Karen Mcdonald who advertise on Radio"?
Or for an example "How many James Robert who living in New York?"
I'm really appreciate for your reply.
That would be the COUNTIFS (notice the S at the end. Let me know if you need an example.
I'm going crazy, how do I count how many people were either rejected or accepted for either a manager position or junior position on a specific day i.e. how many people were rejected for the junior position on 01 January? I've tried sooo many different formulas and none are working.
Use *Countifs* function. Here are dates with accept and reject. I did accept. drive.google.com/file/d/16aH28nxGtdg81DpOpy278GnTR4A3KbX1/view?usp=drivesdk
how you can count or sum the total purchses amount per month
Use the COUNTIFS function. Here is a screenshot showing the formula and some sample data. www.screencast.com/t/o2lQXWhuPtTd
If you wanted to know the count for every month, I would use a PivotTable.
How do I countIF it has two individual things I want to count? Example: 22 SL
I want to count the 22 for an average & I want to count the SL for type of match (league vs league). So I want to count the 22 individually & count the SL individually.
Use COUNTIFS. Notice the "S" at the end. That will allow you to count multiple columns.
COULD YOU EXPLAIN THAT WHAT IS THE FORMULA TO COUNT A SPECIAL SINGLE TEXT FROM CERTAIN COLUMNS ACROSS A ROW FOR MAINTAINING ATTENDANCE RECORD.