Check a table column for value and..

[johnwill8258]

Excel 2013.
For my excel, I want to find the sum of values for those cells that has matching content in the column.

i.e,
In a table:

	B	C	D	E
1	$5.11		TRUE
2	$1.42		FALSE
3	$2.31		TRUE
4			FALSE
5			(FUNCTION)

<tbody>
</tbody>

The last, total row, (FUNCTION), will be used to calculate.
The (FUNCTION) in this case will return $7.42, which is $5.11+$2.31, adding the contents B1 and B3 since corresponding row has its D1 and D3 being TRUE.
I will need help with (FUNCTION).

Additionally, each D column cells have a linked checkbox that will result the cell content being TRUE/FALSE.
How would I format the table so that such cell is applied to all D column? At this point I am manually copying and re-linking each cells.
I've tried macro, but it would create several copies of checkbox instead of one checkbox, and does not re-link.
I've also tried applying the cell format to the whole column, however this also will not re-link.


Help would be appreciated. Thank you!

 

[SpartanAOD]

In D5, enter this:

=SUMIF(D1:D4,"TRUE",B1:B4)

 

[johnwill8258]

In D5, enter this:

=SUMIF(D1:D4,"TRUE",B1:B4)

Thank you SUMIF was what I was looking for.