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.)?

TRUE	4	3
FALSE
TRUE	2	2
FALSE	6
TRUE	2	3
FALSE
TRUE	4	1

<colgroup><col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3620;"> <col width="64" style="width: 48pt;" span="2"> <tbody> </tbody>

=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:

	A​	B​	C​	D​	E​	F​
1​	TRUE​	FALSE​	FALSE​	FALSE​	2​	2​
2​	FALSE​	FALSE​	TRUE​	FALSE​	1​	3​
3​	FALSE​	TRUE​	FALSE​	FALSE​	2​	4​
4​	FALSE​	FALSE​	TRUE​	FALSE​	1​	5​
5​	FALSE​	FALSE​	FALSE​	TRUE​	2​	4​
6​	FALSE​	TRUE​	FALSE​	FALSE​	3​	2​
7​	FALSE​	TRUE​	FALSE​	FALSE​	1​	4​
8​	FALSE​	FALSE​	TRUE​	FALSE​	2​	2​
9​	FALSE​	TRUE​	FALSE​	FALSE​	2​	1​
10​	TRUE​	FALSE​	FALSE​	FALSE​	2​	5​

<tbody>
</tbody>

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