redfishNtrout
New Member
- Joined
- Aug 29, 2019
- Messages
- 3
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.)?
<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.
TRUE | 4 | 3 |
FALSE | ||
TRUE | 2 | 2 |
FALSE | 6 | |
TRUE | 2 | 3 |
FALSE | ||
TRUE | 4 | 1 |
=IF(A1=TRUE,B1*C1)+IF(A2=TRUE,B2*C2)+... is not a plausible solution. Thanks.