countif error

  1. P

    CountIF Closed Workbook

    Hi, I've read the previous posts however none have really been able to fix the problem I'm having. I have a shared spreadsheet that colleagues use daily (MAILBOX LOG), however I want a master spreadsheet that will pull data from each worksheet withing the MAILBOX LOG worksheet. The current...
  2. R

    Runtime error '1004': Unable to get the countif property of the worksheetFunction class.. Please Help!

    Hi all, This is my first post, so bear with me. I am currently populating a whole lot of different/identical data to a worksheet and then using a concatenated string in front of all the different figures I am determining which ones are the same. However I now need to delete the duplicate...
  3. X

    Countif date range

    I have a range of dates (partial example below) and want to find out the number of people with a DOB older than 50 years old. What is the formula? <table border="0" cellpadding="0" cellspacing="0" width="95"><col style="width: 71pt;" width="95"> <tbody><tr style="height: 12.75pt;"...
  4. T

    Fitness Sheet COUNTING help

    Hey guys, I am trying to motivate myself in anyway possible, I figured by creating an excel sheet and seeing some statistics might help, worth a shot. I would post a screen shot but it is way too hard. Anyways, I have a tab for data where I have a column with each date for the remainder of the...
  5. B

    Countifs error in earlier version of excel

    I am trying to use this formula: COUNTIFS('GAME DATA'!$B$7:$B$361,"=W",'GAME DATA'!V$7:V$361,"5") This is an attempt to count the number of times a row has both a "W" in one column and the number 5 in another column. However, in my version of excel it just says "#NAME?". Is there an...
  6. M

    An issue with CountIF and the original data in the fields

    Hello! I cannot for the life of me figure out why I am receiving an error for a simple CountIF formula. I have a total of 12663 items in Column A with duplicates and all I want is to count the number of duplicates for each. It works great for the majority but there are a few that the formula...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top