# False value, other than the weekly total

Closed
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Mar 13, 2014 at 02:57 PM
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Apr 1, 2014 at 06:10 PM
=IF(C1716="","",IF(COUNTIF(C\$2:C1716,C1716)=1,COUNTIFS(\$H\$2:\$H\$11999,1,\$C\$2:\$C\$11999,\$C1716)=1,""))

I enter the above formula to calculate the total number of days that an agy has been used per week, but it gives me false a value, and it's driving me crazy. C is the column for the number of the week. Many thanks
Related:

## 2 replies

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Mar 13, 2014 at 04:08 PM
jutulu, Good afternoon.

Try to cut off this second =1
Before: =IF(C1716="","",IF(COUNTIF(C\$2:C1716,C1716)=1,COUNTIFS(\$H\$2:\$H\$11999,1,\$C\$2:\$C\$11999,\$C1716)=1,""))

Now..: =IF(C1716="","",IF(COUNTIF(C\$2:C1716,C1716)=1,COUNTIFS(\$H\$2:\$H\$11999,1,\$C\$2:\$C\$11999,\$C1716),""))
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 2
Apr 1, 2014 at 06:10 PM
thanks, I read of it. Great!