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
nomiosAsked:
Who is Participating?
 
ajcheung78Connect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.