[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

Countifs not working properly

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
nomios
Asked:
nomios
1 Solution
 
ajcheung78Commented:
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
 
barry houdiniCommented:
>The formulas don't seem to be working in the monthly tab

Which formulas - can you specify the cell/cells?

regards, barry
0
 
chwong67Commented:
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now