Previous Topic Next Topic

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 responses

Answer 1 / 2
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),""))
0
Answer 2 / 2
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

Similar discussions

Removing " false" value in "IF"
JIN -
share -

10 responses
Quick heal removal tools
vyas -
Ambucias -

1 response
Removing "FALSE" from an IF statement with a VLOOKUP
RayRay -
RayRay -

2 responses
No Timer Tick interrupt
HackCMD -
ac3mark -

1 response