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.
Hi Team , For 2nd Scenario , I am using this formula but it is not working showing 0 : =COUNTIF(E1:E66,"True")