Imran Azam
Board Regular
- Joined
- Mar 15, 2011
- Messages
- 103
Hi Guys
i have the table below with some results the score seems to be incorrect i am not sure if its my formula
<tbody>
</tbody>
the formula i use to get the result are as follow for both james and Alex
If(IFERROR(COUNTIFS('Data'!$AC:$AC,"James",' Data'!$V:$V,"Sold",'Win Rate Data'!$S:$S,">=01/05/2019",'Win Rate Data'!$S:$S,"<01/06/2019")/(COUNTIFS('Data'!'Data'!$AC:$AC,"James",'Data'!$V:$V,"Open")"-"))
because there was no data for alex it returns -
The formula i am using for the score is as follow
<tbody>
</tbody>
for some reason it is coming up with the total 20 rather than 10, the issue is it is recording 10 for alex result which is "-"
does anyone know why this is happening?
how can i fix this?
thank for any help
i have the table below with some results the score seems to be incorrect i am not sure if its my formula
a | b | c | |
1 | Name | Result | |
2 | James | 2% | |
3 | Alex | - | |
score | 20 |
<tbody>
</tbody>
the formula i use to get the result are as follow for both james and Alex
If(IFERROR(COUNTIFS('Data'!$AC:$AC,"James",' Data'!$V:$V,"Sold",'Win Rate Data'!$S:$S,">=01/05/2019",'Win Rate Data'!$S:$S,"<01/06/2019")/(COUNTIFS('Data'!'Data'!$AC:$AC,"James",'Data'!$V:$V,"Open")"-"))
because there was no data for alex it returns -
The formula i am using for the score is as follow
=IF(B2>0.2,10,2)+IF(B3>0.1,10,0) |
<tbody>
</tbody>
for some reason it is coming up with the total 20 rather than 10, the issue is it is recording 10 for alex result which is "-"
does anyone know why this is happening?
how can i fix this?
thank for any help
Last edited by a moderator: