Countifs not working properly

Posted on 2011-10-15
Last Modified: 2012-05-12

The formulas don't seem to be working in the monthly tab. The one in the weekly tab seem to calculate just fine.

Question by:nomios
    LVL 3

    Accepted Solution

    If you unhide column P you will find that you do not have any data there as you do in the weekly worksheet.  Copy O2 to P10 and you will have data - I've attached a copy with the change and this is why your countifs functions are not working.
    LVL 50

    Expert Comment

    by:barry houdini
    >The formulas don't seem to be working in the monthly tab

    Which formulas - can you specify the cell/cells?

    regards, barry
    LVL 9

    Expert Comment

    For Weekly Roaming Report, cell V6,
    Formula =COUNTIFS(DataSheet!$D:$D,'Weekly Roaming Report'!$U7,DataSheet!$C:$C,'Weekly Roaming Report'!V$5,DataSheet!$G:$G,'Weekly Roaming Report'!$B$1)
    Changed to
    =COUNTIFS(DataSheet!$D:$D,'Weekly Roaming Report'!$U6,DataSheet!$C:$C,'Weekly Roaming Report'!V$5,DataSheet!$G:$G,'Weekly Roaming Report'!$B$1)

    then copy until Z12.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now