 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 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 !!
Shiv

8 Replies

# Re: Help required in a formula

Hi Team , here is the updated full view of the excel

# Re: Help required in a formula

Hi Team , For 2nd Scenario , I am using this formula but it is not working showing 0 : =COUNTIF(E1:E66,"True")

# Re: Help required in a formula

``=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).

# Re: Help required in a formula

Thank you so much for your response !!
Count is still not working its giving me 0
=COUNTIF(O42:O107,"True")

# Re: Help required in a formula

Can you check if "TRUE " with a space at the end is entered in range O42:O107 instead of "TRUE" without a space.

best response confirmed by vshivku1 (Occasional Contributor)
Solution

# Re: Help required in a formula

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.