Forum Discussion
Solved
Help required in a formula
Hi Team , I need one help with one formula . Below is the screen shot with the scenario . Here is the case : Scenario 1 I want a new column named Weightage , If the column name is Attended...
If true/false are texts, not Boolean, when
=SUMPRODUCT(--( $E$3:$E$13="TRUE") )COUNTIF() in background transform texts which represent numbers and Booleans accordingly.
Thank you so much for your response !!
Count is still not working its giving me 0
=COUNTIF(O42:O107,"True")
Count is still not working its giving me 0
=COUNTIF(O42:O107,"True")
If true/false are texts, not Boolean, when
=SUMPRODUCT(--( $E$3:$E$13="TRUE") )COUNTIF() in background transform texts which represent numbers and Booleans accordingly.
- Thank you so much Sergei , It works as expected