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 , here is the updated full view of the excel
=SUMPRODUCT(($A$1:$A$7=$A$9:$G$9)*($B$1:$B$7*A10:G10))Maybe with this formula as shown in the attached file.
=COUNTIF(I10:I17,"WAHR")This formula is in cell I20 to count the number of TRUE (WAHR in german).
- Thank you so much for your response !!
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.
