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

2 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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),""))
0
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!
0