False value, other than the weekly total Closed

Question

=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

Mazzaropi · Answer

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 · Answer

thanks, I read of it. Great!

False value, other than the weekly total

2 responses

Similar discussions

Subscribe To Our Newsletter!