Solved

# Countifs not working properly

Posted on 2011-10-15
152 Views
Hi,

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

EESsmple.xlsm
0
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.
EESsmple-updated.xlsm
0

LVL 50

Expert Comment

>The formulas don't seem to be working in the monthly tab

Which formulas - can you specify the cell/cells?

regards, barry
0

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.
0

## Featured Post

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.