Forum Discussion
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 then it should be multiplied by 1.5 and so on with the other values , even if the column order changes I mean if today column A is Attended then we multiplied with 1.5 , but tomorrow if Column B is Attended then automatically the formula should multiply column B with 1.5 .
| Attended | 1.5 |
| Content Syndication | 0.5 |
| Other | 0.5 |
| Outbound Telemarketing Qualified | 0.5 |
| Request Rep Email | 1.5 |
| Scheduled Consultation Occurred | 1.5 |
| Web Response | 1 |
Scenario 2 :
I need help in creating formula which calculates the count of all "True" Values for a given range .
Quick response is deeply appreciated !!
Thanks in Advance
Shiv
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.
8 Replies
- Hi Team , For 2nd Scenario , I am using this formula but it is not working showing 0 : =COUNTIF(E1:E66,"True")
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")
