Wow... glade to hear that it still works after 8 years!

support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb

@@StephenRansom i need to counting formual

That's what this video is showing. It doesn't matter what sheet... or even what workbook, for that matter, the data resides on.

I'm fairly certain it was 2010

Guillem, it shouldn't have anything to do with an outdated Excel version. It is amazing how you can have the smallest problem with your syntax which will stop a function from working. I would suspect this is the issue. It's very hard sometimes to see your own flawed syntax, especially when it can be as small as a comma, space or period.

​@@StephenRansom Thanks a lot for your answer! I think it's actually due to the fact that Excel is not capable of applying the "COUNTIF" nor "COUNTIFS" functions to 3D ranges. At least, that's what I've been able to find out in the internet (both informal forums and the official Microsoft support page). Thanks anyways for your quick answer! :)

@@guillemramos6352 No problem. I'm not sure what your data set looks like, but perhaps you need to use a LOOKUP function? (VLOOKUP/HLOOKUP) or INDEX function?

Nia, have you tried the COUNTIFS function? It allows you to use multiple criteria and ranges in a single argument. Or, you can also use =COUNTIF(...)+COUNTIF(...), etc... It's hard to give specific advice without knowing the exact scenario and data setup.

Definitely possible. Not something I can really explain in a comment. You can combine countif functions... ie. =COUNTIF( )+COUNTIF( ), ETC.... But, if I am understanding you correctly, this is a basic countif problem. You just identify the column range of good/bad and count the criteria that you need (good or bad).

You're welcome!

So glad it helped!

Did you watch the video? That's what it shows how to do.

Kong Vina Yes, and even across workbooks.

Don't be afraid to google your question. www.extendoffice.com/documents/excel/2540-excel-countif-multiple-criteria.html You might also want to look at =COUNTIFS exceljet.net/excel-functions/excel-countifs-function

Sorry, that's a very general error... could be many things. In general, there is something wrong in the formula you typed or in the cells/sheets being referenced. There's no way I can be more specific that that without actually seeing your file.

I don't see anything wrong with it, but without the workbook, it's hard to troubleshoot.

Thanks! Glad it helped.

Check your syntax to make sure the formula is referring both the the column(s) and the sheet(s) in question.

I'm not sure I understand your question. This video shows how to use this function across sheets.

Hunter Abrams www.mrexcel.com/forum/excel-questions/214542-countif-whole-workbook.html

Glad to hear it!

Great! Glad to hear it was useful to you.

You're welcome! I'm glad this old video is still proving helpful.

Great!

You count only in the range of the last 2 weeks.

You're welcome. I'm glad it helped.

Glad it helped! I made this video 3 years ago. I can't believe that Weebly hasn't developed better integration for this yet.

Hello there. Could you help me with this, please? I'm working in google sheets and I'd like to know how to count the number of times a word appears in a column however some cells contain more than one word. So, in a nutshell, how can I add the total number of times a word appears in a column whether it appears alone or it shares the cell with other words. Your countif. Thanks for your help..

Glad it helped!

dmack5205 Thank you. Glad to hear it.

Sure it's possible. Just make sure that your formula syntax includes the entire range of possible data, even if it isn't there yet. The countif function will count whatever is in that range, whenever it gets submitted/entered.

Thank you for such a quick response. Do you put "double quotes" around every single data entry? Commas as well? Like this: =COUNTIF('Patient Details'!D2:D200,"Moved""Financial/Cost""Not Ready""Emailed Patient") Also, on the first sheet I have a list of outcomes on each row. If the formula includes the entire range of possible data, then how will I be able to determine the number of times a certain piece of data was selected for that particular row? Hard to explain. Basically I have 21 outcomes the end user can chose from on the second sheet for each patient file that they audit. They are supposed to track this data on the second sheet and select and outcome for each file. I want that information to be tallied up on the first sheet for each outcome; i.e. moved, financial/cost, not ready, emailed patient, etc. Thoughts?

Something to note, you do not need the item to be counted in " ". Instead, you can just click on the cell reference that contains the item to be counted (as shown in this video). Now, typically, COUNTIF is used to count a single variable. You can combine different variables with with + , i.e. =COUNTIF( )+COUNTIF( )+... But, it sounds like you are actually wanting to use COUNTIFS to count multiple criteria in the same expression. Search KZbin for "countifs with multiple criteria" and see if that is more what you are looking for. I can't tell exactly by our description what you are wanting to do and if this function is the best way to do it.

Ok great! I certainly appreciate your help and fast response. I love Excel, but the learning curve is steep and trying to explain things is proving to be difficult. Thanks again.

Yes... much easier to show than explain. Good luck! The answer to "can Excel do this" is always yes. It's an incredibly sophisticated software application. KZbin and Google are your friends here :-)

You do it the same way as shown in this video, selecting the multiple ranges from the multiple worksheets that you want counted. Or if more appropriate, use the COUNTIFS function support.office.com/en-us/article/COUNTIFS-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842

Thierry H the best way to do this is to add a new section break before the references page. Then, in paragraph settings you can add the hanging indent and only apply it to this new section. Whenever pages need custom formatting from the rest of the document new section breaks are best.

Have you set the correction reference/citation style? Typically, it is the reference/citation style (APA, MLA,...) that drives this.

Yes, i referenced ok. Please here is my problem (Thank you, sir): tinyurl.com/apa-problem

Could this be the issue? answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_mac/how-can-i-convince-word-to-use-english-instead-of/e0718ad9-03aa-4218-b318-e7a68d8eee5c

You're welcome! I don't know why Microsoft has dropped the ball on offering a correct APA option here.

Glad you found it helpful!

Ecosleeve Glad it helped.