johnwill8258
New Member
- Joined
- Sep 15, 2016
- Messages
- 14
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:
<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!
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 (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!