Solution Appreciated

[redfishNtrout]

Extremely large data set that will include the following information. Is there a simple method (formula) to provide the following summation (for a large data set,A1:A200, etc.)?


[TABLE="width: 170"]
<colgroup><col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3620;"> <col width="64" style="width: 48pt;" span="2"> <tbody>[TR]
[TD="width: 99, bgcolor: transparent, align: center"]TRUE[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]4[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]FALSE[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]FALSE[/TD]
[TD="bgcolor: transparent, align: right"]6[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]FALSE[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]


=IF(A1=TRUE,B1*C1)+IF(A2=TRUE,B2*C2)+... is not a plausible solution. Thanks.

 

[Fluff]

Hi & welcome to MrExcel.
How about
=SUMPRODUCT(A1:A7*B1:B7*C1:C7)

 

[redfishNtrout]

Thanks and I should apologize. I did not fully explain mydilemma. Given the following:


[TABLE="width: 336"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"]

A​

[/TD]
[TD="width: 64, bgcolor: transparent"]

B​

[/TD]
[TD="width: 64, bgcolor: transparent"]

C​

[/TD]
[TD="width: 64, bgcolor: transparent"]

D​

[/TD]
[TD="width: 64, bgcolor: transparent"]

E​

[/TD]
[TD="width: 64, bgcolor: transparent"]

F​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

1​

[/TD]
[TD="width: 64, bgcolor: transparent"]

TRUE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

2​

[/TD]
[TD="width: 64, bgcolor: transparent"]

2​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

2​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

TRUE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

1​

[/TD]
[TD="width: 64, bgcolor: transparent"]

3​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

3​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

TRUE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

2​

[/TD]
[TD="width: 64, bgcolor: transparent"]

4​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

4​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

TRUE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

1​

[/TD]
[TD="width: 64, bgcolor: transparent"]

5​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

5​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

TRUE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

2​

[/TD]
[TD="width: 64, bgcolor: transparent"]

4​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

6​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

TRUE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

3​

[/TD]
[TD="width: 64, bgcolor: transparent"]

2​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

7​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

TRUE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

1​

[/TD]
[TD="width: 64, bgcolor: transparent"]

4​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

8​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

TRUE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

2​

[/TD]
[TD="width: 64, bgcolor: transparent"]

2​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

9​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

TRUE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

2​

[/TD]
[TD="width: 64, bgcolor: transparent"]

1​

[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]

10​

[/TD]
[TD="width: 64, bgcolor: transparent"]

TRUE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

FALSE​

[/TD]
[TD="width: 64, bgcolor: transparent"]

2​

[/TD]
[TD="width: 64, bgcolor: transparent"]

5​

[/TD]
[/TR]
</tbody>[/TABLE]


I want to sum of E*F for all TRUE cell entries in column A(= 14). Similar solutions for columns B,C, D, and E. Data set includes approx..40 columns and 700 rows. Thanks.

 

[redfishNtrout]

I failed to provide enough information. Given the table below, what is an economical way to calculate, when a true is present in a column, the sum of all E*F's for that column (for column A the solution would be 14). Additional solutions for B, C, .. The actual table I am working with is extremely large. Thanks.

 

[Fluff]

In that case use
=SUMPRODUCT(A1:A10*$E$1:$E$10*$F$1:$F$10)
and drag to the right